DBCC OPENTRAN will give you transactions that are open.

with the spid you get issue a KILL command which will end the transaction.

A database can have only one mdf file.So you cannot split this.

My main initension is to...

Take the full backup of the DB,copy it and restore it on another server.You cannot split the mdf file.

If the backup is again >5GB,take striped backup.Refer BOL for this.

In 2008...

There is an option in the configuration wizard about the source dircetory.

I think you have given \\U-LPL-PROD-18\MNDT_Batching_Logs there.give primary's folder here.

Also for the secondary, create a separate folder instead of...

Yes, the source directory should be your primary server's shared folder.Also give full permissions to the shared folders on both the servers.

Re-configure again by giving the correct paths.

Also on secondary...

Script out the logins and execute the script in 2005 master database.

Who changed it -- we cannot trace unless you were running a trace.iam not sure .

when it was changed--

USE Master

GO

SELECT [name],create_date, modify_date

FROM sys.sql_logins

WHERE [name] = 'sa'

NO

but you can create both the tables and later create the foreign key constraints.

Add the dbserver1 as linked server on the dbserver2.

Then you can query the dbserver1 table from dbserver2 as:

select * from dbserver1.databasename.schemaname.emp

Please post the error message you got.

There's no such bug in 2008

The answer is NO.Unique constraint can have only one NULL value.All the rows in that column should be unique and so it accepts...

Why do you want to shrink the file?

SELECT TALLY_NAME FROM TALLYS WHERE LAST_UPDATED_DATE < '04/15/2009'

try this...

A single computer(server) can have many sql server installations.Each computer can have 16 instances.(50 in 2008).One will be the default instance and the rest are named instances.

So instance is not...

Please post the query in which you sorted .With an ORDER BY clause you can get the results you desired.