I knew, i will step on 'cursor killers' 🙂 🙂

Sure, thank you for the offer.

Need some time to modify script ( for security purposes ) before i can 'publish...

Thank you for the info.....

However, it does sound toooooo cumbersome.

All we need is an ability to track schema\option\config changes with all the change detailes

And ability to fall bck to the...

But the whole reason for multiple files is to spread the load between all those tempdb files.

And in total it’s equals to 8 GB for data and 8 GB for...

were there any resolution for that problem you reported?

it seems like we had the similar error message for different windows services after that

windows forced a restart to them....

and recently...

unfortunately i can't use msdb database...

those files are collections of prod backup files from different servers that needed to be restored

on the QA server

thank you for your time guys

i am not really a programmer....

can you show me how to replace original 'where' with yours ...syntax wise

does this looks proper to you?

don't...

Sorry.... 🙂

Here's the script. Actually, it's a dynamic database restore script.

It's reading all the backup files names in the specified directory.

Then, it inserts in the @T table all ...

i did....

still, 'select from' is coming up with no records

my fault...

above script is a beginning of the loop...

here is what following the script above:

set @iT=1

WHILE @iT<=(SELECT MAX(iT) FROM @T)

BEGIN

SELECT @fileCode=fileCode FROM @T where iT=@iT

SELECT @fileCode

unfortunately, your solution didn't work

looks like your stmnt it's still missing ZX at the end....

will not work

install sql entrpz mngr V9

run sql 2005 install cd, and choose tools only

can be done on your workstation

Can you please elaborate on appl encryption?

What about permissions that they can do db maintenance only?

i'm thinking... it will be at the hosted site

Thank you ALL for the info!!!

However I do have a question. Why does it meter how many characters is in the alphabet?

As long as the nvarchar or nchar is...