Try SET DATEFORMAT command.

Use "create database forattach".

CREATE DATABASE PR2

  ON

 (name = 'PR2DATA1', filename = 'S:\PR2DATA\PR2DATA1.MDF'),

 (name = 'PR2DATA2', filename = 'S:\PR2DATA\PR2DATA2.NDF'),

 (name = 'PR2DATA3', filename = 'T:\PR2DATA\PR2DATA3.NDF'),

 (name = 'PR2DATA4', filename = 'T:\PR2DATA\PR2DATA4.NDF'),

 (name = 'PR2DATA5', filename = 'T:\PR2DATA\PR2DATA5.NDF'),

 (name...

Run DBCC USEROPTIONS to see any difference in servers.

It sounds like you were trying to delete data in linked server. We need more information about your system environment and also post your stored procedure too.

What type of system monitoring are you referring to?

Check your machine system and application logs, Most likely you have hardware problems in I/O subsystem.

Check Microsoft KB 828339

http://www.sqldts.com

Without turning on 'AWE' , SQL Server will not be able to use memory beyond 4GB boundary and will complete the 3GB memory with SAP within 4GB.

"DBIF_RSQL_SQL_ERROR" is very...

It will improve the performance but be sure do not truncate existing data.

Try to find out the longest data in a column by select max(len(columnname)) from your table.

If you are seeing system resources usage is high, run sp_who2 active to find out which spids are running.

Try to replace exec sp_executesql @v_sql with exec (@v_sql)

Also check machine application and system logs for any information may related. You may also have SQL Server dump file created in SQL Server log folder. In order to analyze...

Use Cluster administrator to take SQL Server Agent resource offline, rename the original msdb database files (both mdf and ldf), replace them with the files from old server and bring...

Why Not?

Just curiously, How do you know the memory usage is increasing ......?