I'm working on a development which may end up as having the largest SQL Server database in Europe, its not quite 800 GB at the moment but the project has...

I think you are not getting any replies because we have all seen the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

statement at the start of you script. Look up what this...

Has the password been changed, look in SQL Server configuration manger and ensure the right password in stored. Another thing to look at is trying to start the service from...

It may be because the collation of the databases are different, one being say UK one being US, and the date is being entered not by a date field but...

You still have to create the #Results table for the second script to work.

Regards

Carolyn

You could try having the identity key on one side all the even numbers and the identity on the other all the odd numbers. in that way the numbers shouldn't...

This might help....

IF EXISTS (SELECT * FROM tempdb..sysobjects

WHERE id = object_id(N'[tempdb]..[#Results]'))

DROP TABLE #Results

CREATE TABLE #Results (ServerName VARCHAR(100), DatabaseName VARCHAR(100), NAME VARCHAR(100), filename VARCHAR(200))

EXEC sp_MSForEachDB

'INSERT INTO #Results(ServerName, DatabaseName, Name,...

Whoever has suggested this must have their reasons, it would be interesting to find out what they are. It doesn't really make sense to replace a tool that is free...

I've seen this done in a number of ways but firstly you need to do some analysis of the reports required.

I always ask questions.

Is the same report run for each...

As far as I know log shipping won't let you do this, log shipping is exactly what the name implies a copy of the logs shipped our to a new...

Log shipping wont help you as if you change the source database by deleting records the target records will also be deleted in the logs that get restored to the...

If you post some example data perhaps someone here can give you a head start.

It was a long time ago but I think that the MSDTC settings needed to be set to allow distributed transactions, as the patch we applied stopped distributed transactions. It...

Have you tried looking at one of the tools that create compressed backups like Hyperbac http://www.hyperbac.com or Redgates backup tool http://www.red-gate.com/products/SQL_Backup/index-2.html these tools are designed for the job.

They probably cost...

Has there been and patches put on the server recently, this has happened to me before due to windows patches.