Viewing 15 posts - 31 through 45 (of 2,486 total)
nick.mcdermaid (2/6/2013)
1. If you have only one SQL Agent job being your 'host' you can't run mutliple jobs in parallel
2. If you want to have a...
February 7, 2013 at 4:24 am
Steven Willis (2/3/2013)
Considering something like Contact Info I'd do something like below...
Where's the +1 button. Ton of good info and examples Steve.
February 5, 2013 at 5:16 am
Another very useful resource to track down blocking.
February 5, 2013 at 5:09 am
DB_Newbie2007 (2/1/2013)
"Login failed for user 'NT AUTHORITY\SYSTEM'... "
Is that message coming from the SQL Agent Job, or the code that the job is running?
Are there any other errors or warnings...
February 5, 2013 at 5:03 am
cphite (1/31/2013)
... However, when I try to start the new instance under that account, I get an error saying it cannot start ...
What is the actual error message...
February 5, 2013 at 4:59 am
marygzaudtke (2/4/2013)
USE [ReportServerTempDB]GO
/****** Object: Schema [RSExecRole] Script Date: 02/04/2013 13:45:30 ******/
CREATE SCHEMA [RSExecRole] AUTHORIZATION [RSExecRole]
GO
If you use the Reporting Services Configuration Manager to create the new...
February 5, 2013 at 4:56 am
Sorry you lost me on a few fronts.
1) you reference another article stating, "The method SSIS Data Pump represents the most effective way to load large amount of data into...
February 5, 2013 at 4:46 am
Also, take a look at Enterprise Policy Management Framework[/url] on codeplex.
Allows great policy management and reporting across all accessible SQL Servers, including SQL 2000 & SQL 2005.
April 23, 2012 at 3:47 am
Check out RSScripter, does all that and more ...
January 9, 2012 at 3:42 am
Firstly, I'd ask what is behind the requirement to run the subscription using T-SQL? That really defeats the purpose of setting up the subscription in the first place. When you...
July 6, 2011 at 2:43 am
I'd suggest never run the Profiler GUI on a production server without very limited events/columns and strict filters. Even then, on a very busy server, there will be an adverse...
May 19, 2011 at 3:48 am
Steve Jones - SSC Editor (3/24/2011)
We recorded it and I'll get a link posted as...
April 18, 2011 at 1:45 am
Dang, Phil! Haven't seen you around in a while
Been lurking 😉
April 6, 2011 at 1:32 am
:-D:-D Love that idea Jeff
But seriously, I reckon they need a more stringent posting process so the numerous superfluous cases don't get lodged. If people had to think more about...
April 5, 2011 at 10:30 pm
Caruncles (3/3/2011)
I saw this post and have been banging my head trying to set...
March 3, 2011 at 7:20 pm
Viewing 15 posts - 31 through 45 (of 2,486 total)