191 reputation
16
bio website warriorbob.com
location California
age 32
visits member for 3 years, 3 months
seen 2 hours ago

Programmer-turned-DBA. Lots of things to learn!


Feb
4
comment SQL Server Service Broker messages in one database fails unless SA owns the database? What's going on here?
@Rikalous This is an AD environment but I am connected, however the SQL Server instance is running from my workstation if that matters. Did you run into a similar issue?
Feb
3
comment SQL Server Service Broker messages in one database fails unless SA owns the database? What's going on here?
@AaronBertrand I set TRUSTWORTHY on a new copy of the database (same steps as above, except giving sa ownership) and did not observe a difference. I actually don't have a problem with sa owning databases, I just want to understand why that fixes the issue. Finally, it seems I have some reading to do about principles... I had thought that a schema was a principle. Thank you for pointing out that error!
Feb
3
asked SQL Server Service Broker messages in one database fails unless SA owns the database? What's going on here?
May
1
awarded  Notable Question
Apr
22
accepted What are the hazards of upgrading a SQL Server service pack?
Apr
22
revised What are the hazards of upgrading a SQL Server service pack?
Reworded the first line so it wasn't so open-ended
Apr
22
asked What are the hazards of upgrading a SQL Server service pack?
Sep
26
awarded  Popular Question
Aug
24
revised What is a “Reporting Task for Subplan” task in SSIS, and how can I create one?
Clarified slightly, removed salutation per stackexchange norms (though I appreciate the sentiment! :D )
Aug
24
suggested suggested edit on What is a “Reporting Task for Subplan” task in SSIS, and how can I create one?
Aug
24
accepted What is a “Reporting Task for Subplan” task in SSIS, and how can I create one?
Aug
23
comment What is a “Reporting Task for Subplan” task in SSIS, and how can I create one?
@EricHiggins Sure enough, if I create these same tasks as a Maintenance Plan, export to my desktop, and open in BIDS, I see the Reporting Task. I'd write this up as an answer myself, but I'd rather let you have the rep if you'd like to?
Aug
23
comment What is a “Reporting Task for Subplan” task in SSIS, and how can I create one?
@EricHiggins That is correct; I didn't think there was a difference. I exported it from the server and opened it on my workstation. What was the clue?
Aug
23
asked What is a “Reporting Task for Subplan” task in SSIS, and how can I create one?
Apr
4
accepted Copy a SQL Server 2000 database to another box without interrupting the backup chain
Apr
3
comment Copy a SQL Server 2000 database to another box without interrupting the backup chain
The full backups are scheduled in the middle of the night so I'd rather not come in then, but it's certainly an option!
Apr
3
asked Copy a SQL Server 2000 database to another box without interrupting the backup chain
Mar
27
awarded  Scholar
Mar
27
accepted Can I be automatically notified of prolonged blocking in SQL server?
Mar
27
awarded  Editor