the tools sold can 'reverse engineer' the code to undo a particular transaction.

you will need a third part tool for this, redgate and lumigent sell them.

with SQL2000 sp_helprevlogin does not take across default database or language, so script those out from the source server and run on the destination once dbs created.

set quoted_identifier off

select 'sp_defaultdb...

Hugo, thanks for the detailed reply, appreciated.

I think we can also say that if the result set of the cursor won't fit into cache, we shouldn't be using a cursor!

But do please read the rest of the thread as well. Someone pointed out to me that I only tested with tables that can be completely fit in cache. Once...

Mike Hinds (7/3/2008)

---

Anyone: How can we get Backup Exec to STOP backing up the databases? It completely destroys my strategy of Weekly Full, Daily Differential, Hourly Log.

In some cases I...

agreed its a pain, espec if you are talking about multiple apps. but it's doable and Cannot see any other way. Will be a performance hit as well so admin...

yep a weird request and there is going to be an overhead in doing it. I would confirm the reasoning behind this request. Point out this is not inbuilt into...

do you have a valid id on the sql instance?. see if you can connect to it via Query analyser.

Tao Klerks (7/2/2008)

---

Hmm, I'm a little confused...

I assumed the question was talking about files from any arbitrary database - but the "ALTER DATABASE ... MODIFY FILE" clause can only (if...

strictly speaking, with backup\restore method you do not need to drop the database in between.

thought that might be a catch but went with it as it would still work as...

I would still run the checkdb without the repair option, will save having to put it into single user mode and thus require downtime. checkdb is not particualrly intrusive in...

maybe another connection got in before this job so it could not connect to set back to single.

I would also question why do this in the first place, why run...

the 'virtual device' usually means sone third party software is being used to backup the databases, perhaps legato or veritas.

add the stats clause to the restore command, see BOL