Reputation
1,271
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 13 44
Newest
 Caucus
Impact
~90k people reached

Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 i didn't include it, but there were messages in the app log that explicitly stated "backup of database x failed".
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 scheduled sql server maintenance plan.
Jun
11
comment Severity 016 Backup virtual device fail
@Cougar9000 yes, all databases. yes, it works at toher times, but seems to always fail on sundays.
Jun
11
awarded  Informed
Jun
11
asked Severity 016 Backup virtual device fail
May
14
awarded  Popular Question
May
13
awarded  Caucus
May
11
awarded  Yearling
Apr
29
awarded  Benefactor
Apr
29
comment What could cause the wrong ID to be inserted?
Interesting. I am going to look into this.
Apr
26
comment What could cause the wrong ID to be inserted?
yes, the first one sets the id to 0, so when the next record is inserted sql server takes the current id, adds 1, and gets 1. the next one the first id i would get is 2.
Apr
24
comment What could cause the wrong ID to be inserted?
@jnk we are not inserting data into identity columns anywhere in the application.
Apr
22
accepted Prevent users from using power pivot excel connections to a database
Apr
19
revised Compress backup file using T-SQL
cleaned up grammer
Apr
19
suggested approved edit on Compress backup file using T-SQL
Apr
16
comment Prevent users from using power pivot excel connections to a database
Also, @kin, power pivot shows up with the application name "Microsoft Office 2010". I set it up to block anythign with "Office" and it seems to work. Testing it out with my boss now.
Apr
16
comment Prevent users from using power pivot excel connections to a database
well it was my boss that was inquiring about this, he fould the permission hole. I don't want users connecting to my oltp databases unless it's through an application.
Apr
16
accepted dbo.DTA_* tables in MSDB
Apr
16
asked Prevent users from using power pivot excel connections to a database
Apr
12
revised What is the best permissions to set for only creating and managing own databases?
removed "Thanks"