Reputation
984
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 15 28
Impact
~110k people reached

  • 0 posts edited
  • 0 helpful flags
  • 35 votes cast
Jan
31
asked return percentage of records based on value in column
Jan
28
comment Invalid use of side-effecting operator 'INSERT EXEC' within a function
Aaron Bertrand - I'm looking to send in a SQL query as @SQL and return a delimited list of the results.
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 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