Viewing 15 posts - 16 through 30 (of 104 total)
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...
December 6, 2011 at 8:39 am
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...
June 7, 2011 at 9:31 am
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...
March 4, 2011 at 7:46 am
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...
February 24, 2011 at 8:47 am
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
January 13, 2011 at 9:38 am
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...
January 13, 2011 at 8:10 am
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 ...
January 13, 2011 at 7:42 am
i did....
still, 'select from' is coming up with no records
January 13, 2011 at 6:27 am
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
January 12, 2011 at 2:24 pm
unfortunately, your solution didn't work
January 12, 2011 at 1:49 pm
looks like your stmnt it's still missing ZX at the end....
will not work
January 12, 2011 at 12:54 pm
install sql entrpz mngr V9
run sql 2005 install cd, and choose tools only
can be done on your workstation
May 13, 2010 at 8:02 am
Can you please elaborate on appl encryption?
What about permissions that they can do db maintenance only?
May 12, 2010 at 6:57 am
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...
March 16, 2010 at 2:18 pm
Viewing 15 posts - 16 through 30 (of 104 total)