http://blogs.msdn.com/b/gertd/archive/2008/08/21/getting-to-the-crown-jewels.aspx - there are links in this article to some sample parsing code.

The Microsoft.Data.Schema.ScriptDom.Sql Namespace (details here -> http://msdn.microsoft.com/en-us/library/microsoft.data.schema.scriptdom.sql.aspx) seems to have enough support for parsing requirements.

There's also a walkthrough...

After some more re-reading of BOL - it looks like this is mainly used to freeze a plan and not to provide query hints.

From BOL:

You can use this stored...

Also this article for some more information on the performance counters - http://www.sqlsoldier.com/wp/sqlserver/databasemirroringperformancecounters

When I ran query ver #1, it took 4 minutes.

Then I make a small change (Query ver #2) and it takes 4 seconds.

I re-run #1, and it now takes 4...

A search on error 547 related to replication indicates that this is generally caused due to a constraint violation (for e.g. deleting records from the parent table before deleting them...

You can execute sp_browsereplcmds on the replication DB(info about this here -> http://msdn.microsoft.com/en-us/library/ms176109(v=SQL.100).aspx)

Plug in the xact_seqno to this command and you'll get information about commands involved (the command column in...

You can try using the @schema_option parameter for sp_addarticle to map new data types to older versions:

From http://msdn.microsoft.com/en-us/library/ms173857.aspx:

Schema option value: 0x200000000

Description:

Converts date and time data types (date, time, datetimeoffset,...

One option could be to use MDW to collect query statistics related information on which you can report out.

DMVStats[/url] is another tool - I don't know if this works...

The table Invoice_lines is not aliased in the sub-query - the results from the sub-query can be accessed outisde of the sub-query with the alias (as in the condition "ON...

Would this help -> http://msdn.microsoft.com/en-us/library/ms179887(v=SQL.100).aspx

I've done this quite a few times but never had it fail - what is the complete error message you get when the log reader agent fails? And what does...

You can run the following on the distributor DB to see if it returns any errors:

sp_browsereplcmds @xact_seqno_start = '0x000035E600231E05000100000000',

@xact_seqno_end = '0x000035E600231E05000100000000'

and if that doesn't return anything trim out the trailing...

That's what happens when I update the script without looking at what I did or testing what I did...

Good point. Plus I just realized that I really did not have a partitioned view in my original code.

/*

IF OBJECT_ID('dbo.Testvw') IS NOT NULL

DROP VIEW dbo.Testvw;

IF OBJECT_ID('dbo.TestTab_Main') IS NOT NULL

DROP TABLE...

The script below works if you have an identity column in the table - does the approach below help in your case?

/*

IF OBJECT_ID('dbo.Testvw') IS NOT NULL

DROP VIEW dbo.Testvw;

IF OBJECT_ID('dbo.TestTab_Main') IS...