To use the stored procedure debugger, you need to use RDP or login locally to do it. If you run it from a linked server, you may have this error.

How about this one?

SELECT c.CT_Id CT_Id, c.Category Categor, COUNT(mt.CT_Id)  FROM MasterTransaction mt, Category c GROUP BY mt.CT_Id HAVING mt.CT_Id = c.CT_Id

I found the way.

EXEC sp_MSForEachDB 'USE ? SELECT name FROM sysusers WHERE sid = 0x01 AND name <> ''dbo'''

But yours is better.

Thank you for your input. It works. A weird result was found when I run

SELECT * FROM master..syslogins WHERE sysadmin = 1

Look at the value at sysadmin!

This is a discussed topic about a week ago. The major differences are summarized as follow:

Log shipping ships all data, while replication replicates selected data;

Log shipping does not need special...

SET @STR = 'SELECT TOP '+@count+' ...'

EXEC(@str)

Ha! That is my fault. To find the name of job, we can run the following snippet.

SELECT * FROM msdb..sysjobs WHERE job_id='...'  

Do you use master server to control jobs? If...

It works for both 2000/2005. However, it is not recommended to have this kind of backup. There are two main reasons:

1. Lower speed, in general;

2. Less reliable, in general;

Something like the following snippet:

CREATE TABLE #tmp (col1 INT, col2 VARCHAR(10))

INSERT INTO #tmp WITH (rowlock) (col1, col2) VALUES (1, 'a')

SELECT * FROM #tmp WITH (NOLOCK)

DROP TABLE #tmp

How about the link below?

http://www.softwarevault.com/search.phtml?keyword=ODBC+driver+2000.85.1117.00

Look at the msdb..sysjobs

http://msdn2.microsoft.com/en-us/library/ms179313.aspx

Does it help?

You need to map the drive on other server to your server.

CREATE PROC spTest (@currentDate datetime, @BegDate datetime=NULL, @EndDate datetime =NULL) AS

If @BegDate IS NULL

       Select * From TableA Where EntryDate Between @BegDate and @EndDate

Else

    Select * From...

All replies indicate that we should run statistics in a regular basis. But how often? What is the criteria to make such a decision?

Many thanks for all of you for...