T NOCOUNT ON

/* Declare Cursor for Databases to BE EXCLUDED */

DECLARE DatabaseList CURSOR FOR SELECT name FROM master..sysdatabases

WHERE rtrim(lower(name)) not in('master','model','tempdb','msdb')

ORDER BY name

DECLARE @AltrDBStr varchar(200),

             @AltrDBStr2 nvarchar(200),

             @DB_Name...

https://s.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/alertus.asp

Can you run the insert during low system usage time?

It looks like you have blocking issue. Read KB at http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453

Not as I am aware of.

SQL Server enforces locking automatically by itself. You can't do anything about to release locks.

A range of table-level locking hints can be specified using the SELECT, INSERT, UPDATE, and DELETE...

Service pack installation creates separate installation log file in c:\winnt directory each time.

You can't uninstall service pack for SQL server.

It seems related to Severity levels. The backup failure generates Severity levels 16 and Severity levels from 11 through 16 are generated by the user, and can be corrected by the...

"I could insert a batch of records into with the hope that SQLSvr would insert records that didn't already exist in Table1 and ingore (not insert) any that already did exist...

When READ_ONLY is specified, the database is in read-only mode. Users can retrieve data from the database, but cannot modify the data. Because a read-only database does not allow data...

if user cancels the transaction, then SQL Server will roll the transaction back. A ROLLBACK statement backs out all modifications made in the transaction by returning the data to the state...

SQL Server will not release the memory it has already allocated until other processes ask for memory.

Which Windows process does the paging?

I doubt about it but why you can't use a permanent table?

It seems you tried to insert more than one records from server1 table to server2 table.

Create linked server server1 to be linked to server2, create procedure to perform insert like insert into table2...

When creating an index, you can specify a fill factor to leave extra gaps and reserve a percentage of free space on each

RESTORE HEADERONLY from disk = 'd:\northwind.bak' command will tell how many backup sets in that media.

restore database northwind from  disk = 'd:\northwind.bak' with file = 2. 'file = 2' tells you...