Viewing 6 posts - 1 through 6 (of 6 total)
I think I get it now! Thanks for the tips, everyone!
September 22, 2016 at 8:12 am
Fantastic! Thank you! Question though, how do I convert this over to actually dropping the users while still maintaining the current database? I eventually want to execute the statement as...
September 22, 2016 at 7:52 am
Whoops, sorry about that! Knew I was forgetting something. The error is as follows:
Error in Redacted.sql
Msg 50000, Level 15, State 1, Line 60
Error Number: 102, Severity: 15, State: 1, Line:...
September 22, 2016 at 7:11 am
This worked great, thanks!
September 20, 2016 at 12:19 pm
Hmm, I think I understand. So I would need to include the whole inner cursor loop inside @CreateDB and then execute it in order for it to work as I...
September 20, 2016 at 10:43 am
Just kept spinning, perhaps because View3 is rather large...or it could be that it doesn't really work, I've had that happen before too. I don't have my own test database...
September 8, 2016 at 11:26 am
Viewing 6 posts - 1 through 6 (of 6 total)