Viewing 4 posts - 1 through 4 (of 4 total)
Nevermind; I found sp_helpprotect, which was perfect for this! 😀
September 2, 2011 at 8:07 am
I've posted there as well but have yet to receive any replies. Trying as many sources as I can at this point.
April 1, 2011 at 9:06 am
Worked perfectly. Thank you so so much!!!:-D
February 28, 2011 at 2:08 pm
Hi again,
I've gotten this far and can't seem to get the quoting right;
declare @cmd1 varchar(500)
declare @cmd2 varchar(500)
declare @cmd3 varchar(500)
set @cmd1 ='exec sp_MSforeachtable ' +
'exec sp_MSforeachdb @command1=''SELECT
tbl.Name, ...
February 25, 2011 at 3:23 pm
Viewing 4 posts - 1 through 4 (of 4 total)