Did you run it as-is?

You need to replace the string UID with the "proper" job_id from your msdb..sysjobs table - I have no idea what the job_id's stored in your...

Are you positive you are a member of the local administrators group on your machine?

Yes, it is needed. It's basically a "tempdb" for SSRS. It's basically used to store snapshots of data while reports run.

I have to ask, "why" do they want...

They also recommend sizing...

The TSQL I posted above will work for this, simple tweak here and there...just add in a join to sysjobhistory for cases where you are checking for something in the...

This is the best stab I can take at it, perhaps Lynn can drum up a much nicer approach 🙂

Main Scalar FunctionALTER FUNCTION dbo.fx_GetAliasID (

@Table sysname, @Value varchar(6)

)

RETURNS varchar(500) AS

BEGIN

DECLARE...

In SQL 2005 & 2008, Under SQL Profiler Options there should be a radio button under "File Rollover Options" to say "Prompt before loading rollover files". And yes, there...

I am confused and perhaps just missing the obvious. You just want to return the column name for the column that's the PK in any given table? DECLARE @Table...

These links may help - http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/5c79be1c-f450-4c81-9112-d529c6f04fac/

And - http://www.sqlservercentral.com/Forums/Topic937282-1549-1.aspx#bm938750

Since you want to check the current status of the job, I'd use sysjobactivity. Perhaps something like this?

WHILE (

(SELECT TOP 1 ISNULL(last_executed_step_id, 0)

FROM msdb.dbo.sysjobactivity

WHERE job_id = 'UID'

ORDER BY...

Try something like this:CREATE TABLE #test (servicedate date, eligdate date)

INSERT INTO #test

SELECT '8/6/2012', '8/4/2012' U-N-I-O-N ALL

...

I know this sounds weird, but try setting the classifier function = NULL beforehand, then assign it

ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = NULL);

GO

ALTER RESOURCE GOVERNOR RECONFIGURE;

GO

Then run:ALTER RESOURCE GOVERNOR WITH...

1. Check the latency for the subscription/publication in the replication monitor, 2. Check for errors, 3) How many undistributed commands do you...

Definitely test, then test some more 😉 Increasing the volume of the data in the batch will have it's own overheard on your transaction log.

Beat to the punch on this one 😀

Dwain has made some very valid points!

@Dwain, are you referring to CDC (Change Data Capture)?