Reputation
1,866
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
11 26
Newest
 Yearling
Impact
~122k people reached

Sep
21
comment Consolidating data changes in SQL Server by team
Posted a follow up to my answer.
Sep
21
revised Consolidating data changes in SQL Server by team
added 607 characters in body
Sep
21
answered Consolidating data changes in SQL Server by team
Sep
21
asked Dropping One Computed Column Causes All Computed Columns To No Longer Replicate
Sep
20
awarded  Popular Question
Aug
28
comment Can't Restore DB Because of Active Connections
Are you using a 3rd party tool or scripts to do the restore? If your able to restore from a .bak file using SQL Management Studio there is a check box under options to 'Close existing connections to destination database'. Have you tried that?
Jun
29
comment SSIS Lookup Component Irregularities
What is your source... is it a full table or a query?
Jun
26
comment What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Hmmm, the issue wasn't appearing in the log until a couple weeks ago so if that was the cause... it was only something recent that made the symptom manifest as it doesn't appear in the log earlier than a couple weeks ago.
Jun
26
comment What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Negative... but good thought. We moved the whole server to a SAN storage model last summer, we restored everything during that move but that was months ago.
Jun
26
asked What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Jun
14
comment Format 1,2,3,4 to roman letters for display purpose
Great link @gbn, that was a fascinating read.
Jun
11
comment Are SQL Server's Date values stored as a single int?
now that is nerdilicious +1
Jun
8
awarded  Caucus
Jun
1
revised how to config SSRS 2005 email setting with google apps
added 174 characters in body
Jun
1
answered how to config SSRS 2005 email setting with google apps
May
18
accepted Resource Waits: Mathematical link between Wait Time and Average Waiter Count
May
18
accepted Can you edit the context menu options?
May
18
comment Can you edit the context menu options?
I also agree with your answer... but in this case the rights are part of the job description, we're just brainstorming in a after action mindset here.
May
18
comment Can you edit the context menu options?
+1 for the empathy :)
May
18
comment Can you edit the context menu options?
This is a case where the rights are granted, and must remain due to the fact that its a single tech at a remote center. A do-it-all guy for the operation. We follow your model here at our main office. For example my network login does little, I have another login with .sup on the end that does more. We have a third login that does it all. But in this case - our choices are limited as he regularly needs to do maintenance on the subscriptions (including deleting old adding new). The publication was killed on accident however and that's what I'd like to avoid again.