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...

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...

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...

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...

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...

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 ...

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...

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

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...

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...

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...

>>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...

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...

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...