You are wrong. DTC will not allow two different connections enlisted in the same distributed transaction read uncommitted data from each other without READ UNCOMMITTED or NOLOCK being used.

The...

Make sure you have updated your statistics since your upgrade.

SUSPENDED is usually the process waiting for a non-SQL process to complete. Typically this is your query waiting for the...

You do need the appropriate permissions in the MSDB database. There are some roles in the database - I cannot remember which you need to be a member of....

One thing to add to this. Data driven subscriptions are only available in the enterprise edition of reporting services.

Make sure you look at the feature differences in the editions...

I've written a bunch of variations on this. Recursive CTE's work nice for this:

Recursion limits mean you have to hav a window that is within reason.

WITH DateList (DateValue, DateID)

AS...

Yes, you would have to purchase a license for the second server. MS does not license you to put the individual components of SQL Server on different hardware. ...

If you use an OUTPUT clause in your first update, you can return the "Deleted" and "Inserted" versions of the records affected by the first update.

Return this into a table...

If your worksheet is properly set up as a table, you can use an ExecuteSQL task with a regular "DELETE FROM X WHERE C='A'" type T-SQL statement.

EXEC msdb..sp_start_job is the correct procedure. If the procedure is reporting success and the job agent history is not showing that the job has run, you have probably mis-spelled...

Your "WITH" that it is complaining about is part of the CTE (common table expression).

CTE's are not supported in SQL 2000.

Recursive queries are not supported in SQL 2000.

There are a...

The install will not even work. Most AMD processors these days are 64 bit and can run in both 64 bit and 32 bit simultaneously. If you want...

You really need to read up on notification services before you go any further. Most people seem to misunderstand what it is.

I hope you have types your sample data incorrectly, because you have 1/1/1/2008 for what looks like a date field and in your last line, you have semi-colon delimiters for...

Here would be a CTE example for a list of actual day values.

; WITH DateList (DateValue, Level)

AS

(

SELECT CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE(),101)), 0

UNION ALL

SELECT DATEADD(DAY,-1,DateValue), Level+1

FROM DateList

WHERE DATEADD(DAY,-1,DateValue) >= '1/1/2000'

)

SELECT

DateValue

FROM

DateList

WHERE

DateValue >= DATEADD(DAY,-30,CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE(),101)))

AND DATEPART(WEEKDAY,DateValue) <>...

If you are just looking for a filter, it is pretty easy:

SELECT

*

FROM

MyTable

WHERE

MyDateField >= DATEADD(DAY,-30,GETDATE())

AND DATEPART(WEEKDAY,MyDateField) <> 1 --Not a sunday

If you are trying to actually produce a list of dates,...