network profile
| bio | website | |
|---|---|---|
| location | New York, NY | |
| age | 36 | |
| visits | member for | 2 years, 2 months |
| seen | 30 mins ago | |
| stats | profile views | 41 |
|
Jan 31 |
accepted | return percentage of records based on value in column |
|
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 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 |
