Viewing 14 posts - 106 through 119 (of 119 total)
In general your query looks fine, although the derived table isn't needed here. May be a little simpler to read if written with straight table joins as:
SELECT qlc.Client AS...
December 3, 2004 at 6:59 pm
Rushdi,
Are you trying to list each worksheet in a single Excel workbook? If so, once you have established a linked server to the workbook, execute:
sp_tables_ex <Linked Server Name>
This will list...
December 3, 2004 at 12:52 am
What are the physical specs on the server, in particular RAM and #CPUs? And do the Full Text catalogs share a drive / drive array with your SQL data and/or...
December 3, 2004 at 12:40 am
Is this a migration or a move? Will the machine name change?
In general, there should be no problem with master, msdb, or distribution databases. I've done this precise replacement when...
December 3, 2004 at 12:30 am
I agree with AJ Ahrens above -- a table-valued function is probably your best bet. But if you must used a stored procedure, you can use Openquery instead of Openrowset to...
November 30, 2004 at 6:32 am
Profiler is a little unintuitive in this regard -- not all events return all columns, especially the columns one would think should be populated. In particular, the two you mentioned ...
November 30, 2004 at 6:00 am
You can certainly replicate a view, but what you are replicating is the SQL definition of the view itself, not the data that's returned by the view. The view however...
November 29, 2004 at 2:59 pm
Nitin,
You can get the byte size of the image column by using the SQL function Datalength.
select datalength(image_column) from MyTable
Scott Thornburg
Volt Information Sciences
November 29, 2004 at 2:54 pm
Sahana,
Replication errors and logs are stored with the Replication Agent history.
Go to Replication Monitor on the distributor server using Enterprise MAnager. Expand Publishers and go to the publishing server. Within that...
November 29, 2004 at 2:47 pm
Nev,
Glad it worked for you. This seems to be a problem that trips up many who upgrade to Win 2003.
One point of clarification: a full server reboot is not necessary...
November 29, 2004 at 10:11 am
Take a look at the extended procdure xp_smtp_sendmail from http://www.sqldev.net/xp/xpsmtp.htm. It's easy to use and easy to install, and both safe and secure. I use it on both production and...
November 27, 2004 at 12:49 pm
>>The subquery appears to be indicating that the spid's in master..sysprocesses aren't unique!
This is correct. Sysprocesses can contain multiple rows for the same spid on multiprocessor machines.
Scott Thornburg
Volt Information...
November 26, 2004 at 5:03 pm
I believe the difference you are seeing is due to DTC security settings. When my company upgraded to I Win 2003 ran into a similar problem. The straight RPC call...
November 26, 2004 at 4:34 pm
Alex,
If I'm understanding you right, you want the final output to be in column order from the original stored procedure.
To do that, simply add an order by clause to your...
November 20, 2002 at 2:35 am
Viewing 14 posts - 106 through 119 (of 119 total)