If you do not like cursor, you may do it as below.

1. Make a temporary tabe;

2. Populate data on it;

3. Retrieve new data by comparing the new table and the...

You may try to use cursor.

Here is a link. May it help.

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic17731.aspx

It may be the connection limit, internet traffic jam, or some other reasons. Does it happen all the time or occasionally?

Did you have a chance to read the article below?

http://www.mcpressonline.com/database/db2/db2-integration-with-sql-server-2005-part-i-linked-server-enhancements.html

May it help.

I did several times without any issue.

Do you have sa permission? If not, please check with a person with sa permisstion and see whether or not he will get the same error. Otherwise, you may check...

Again, I am trying, ...

In the backupset table, you can find the backup information, such as what databases had backups, their types, starting time, ...

Say you have a databse, databaseA....

I do not quite follow you why you need both differential and transactional backups.

To solve your disk issue, you may increase the frequency of your transactional backups, say, have your...

I got the same error. It seems that we cannot do it in either SQL 2000 or SQL 2005, although in BOL claims we can do it in SQL 2005.

Should you add OUTPUT AS

CREATE PROCEDURE dbo.Create_Login

(

...

It happens quite often when changing proxy account to another in Services. We had better modify it in GUI.

That is a big number of database servers. If you would like to focus at auditing activities. iMperva may be a candidate.

http://www.imperva.com/

I got the same error while running this script.

I have no problem in changing the collation in GUI but I do have problem in changing it using script in...

The bottleneck of slowness in copying files across servers may be due to the firewall in between. I came across the experience copying a 6 GB file took me over...