When you say 200 replaces does it mean multiple updates/replaces in a column?

Yes Intellisense can be a pain at times.

Hi

You will have to stop SQL Server service. You can do that from Control panel\Administrative Tools\Services. Then you can copy the mdf and ldf files to another db server and...

You can use SSIS. Why no scripts?

A good backup strategy and regular checking of the database's health (dbcc checkdb) is the best way to handle this.

Jeff Moden (10/23/2009)

Sure... at the...

good one Jeff. Can u explain this part - ORDER BY (SELECT 1). I looked up the order by clause but did not fully understand.

---- Being Around Smart People is Exciting

Being Smart is even More Exciting

All the best for upgrading to 2008 🙂

Roust_m (10/22/2009)

Not at all. ...

Lowell has a good idea but you need to make sure that the support people don't change the password expiry and change the SA pwd itself.

The table name and the synonym name would be different. You will have to change the code wherever you have coded with the tablename

Will taking a tail-log backup if possible help?

Skeeve

Are you using any date columns in the join or the where clause?

It would be helpful for everyone if you could post the table definitions , data to be...

ChiragNS,

Thanks for the 2 points. I am not going to try the 'page restore' method, but good to be reminded of options. I guess you could do it all with...