I greatly appreciate your input. INFORMATION_SCHEMA is a view. But could you tell me where I can find it? However, I believe we can only get a list of all...

Could you check the file size, then use dtsrun commad?

I believe that using sp_addserver is the best choice.

Did you restore the database or import/export data? If you restore the database, you should not have any problem. If you use import/export, you may miss the two tables. It...

I applied SP4 with the latest hot fix 8.00.2187 for over dozen SQL Server. All of them work fine.

Based on help online, severity level 19 indicates an SQL Server error in resource. You should be able to find what is process 60 from master..sysprocesses table. You can start...

Try sp_password

You may not temporarily enable a subscriber, but you can delete a subscriber.

Are you sure your Log Reader Agent start?

sp_repaddcolumn is used to add to a published article (table). We do not need to reinitialize the snapshot agent. It is very useful for a big article.

If the article...

I would like to

create a table in your central control box;

Input all server names you would like to scan;

Use a cursor to run this stored procedure in a loop.

I...

If you would like to use stored procedures in your central control box, I agree with John that you need to link servers. If you would like to use stored...

Is it possible to kill the spid after finding the account is being used? We can include a message before killing the spid.

You got to be careful if you have any DTS packages saved with passwords.

I experienced the same problem two months ago. It is a problem in registering the Service Principle Name (SPN). You need to have at least domain admin privilege to fix...