810 reputation
618
bio website
location New York, NY
age 37
visits member for 3 years, 1 month
seen Apr 14 at 13:10

Jan
28
comment Invalid use of side-effecting operator 'INSERT EXEC' within a function
Lamark - so I would want to use a stored procedure to accomplish this then it sounds like.
Jan
28
asked Invalid use of side-effecting operator 'INSERT EXEC' within a function
Jan
8
comment Advice about Backup Solution
Thanks Thomas. It's not that we can't do a full backup. A full backup or differentials by themselves don't get me much further than the file level. Sounds like I need to talk to them about how long they store the transaction log backups for and make sure I can get a hold of them.
Jan
8
accepted Advice about Backup Solution
Jan
7
asked Advice about Backup Solution
Dec
3
comment Identify why a user can drop a database
It was the Alter any Database permission
Dec
3
comment Identify why a user can drop a database
it was the alter any database permission. Thank you.
Dec
3
accepted Identify why a user can drop a database
Dec
3
revised Identify why a user can drop a database
added 330 characters in body
Dec
3
comment Identify why a user can drop a database
I can drop databases as that user. Yes. If you are asking if anyone has used the account meliciously I'd rather not wait to see.
Dec
3
reviewed Approve suggested edit on Identify why a user can drop a database
Dec
3
asked Identify why a user can drop a database
Dec
3
accepted Only a single WITH MOVE clause should be specified for any logical file name
Dec
3
comment Only a single WITH MOVE clause should be specified for any logical file name
Isnt backup name supposed to be the name of the backup database? Or do I need to specify that it is the backup databases mdf and ldf files respectively?
Dec
3
asked Only a single WITH MOVE clause should be specified for any logical file name
Dec
3
comment User already exists error
Thank you. I need to talk with the company owners and the director of development to see if this will work. Are there any security pitfalls to scripting this as a backup and restore?
Dec
3
accepted User already exists error
Dec
1
asked User already exists error
Nov
6
comment How do I automatically grant all privileges to a schema created by a user in mysql?
so you have a user who has permissions in schema a. but is creating objects in schema b? Or does your user only have permissions to a specific set of objects?
Nov
6
answered Optimizing SSIS Packages