The solution to the problem is to include the View create scripts (for all those of the syntax SELECT * FROM OPENQUERY()) in the post-deployment script file as included files.

I...

For now I am excluding all views [using theOPENQUERY (via LINKED_SERVER) from the project] and building them manually after the deploy.

I am not insisting on the step in the middle (SQL 2005), only on testing thoroughly. It was probably mentioned as an avenue of gradual upgrade towards the goal...

Hi Gail,

It seems to be a popular problem, i.e. to have the tempdb created with collation Latin1_General_CI_AS, and another by the other collation SQL_Latin1_CPI_CI_AS and then having collation...

I think what Bitbucket is trying to tell you, is that you should wade into the water instead of diving in head first.

Once you have ironed out the obvious problems,...

It would seem that your collation clash is between the SQL database collation and that of a field stored by the Windows operating system.

For example, if you compare...

There is a Micorosoft Case study listed about the MySpace adoption of Service Broker available.

It would seem that the most profound issue with I/O verbosity is the opening and closing...

RAM Disk is available for Windows 2008 32/64bit DataRam.com, apparently also free.

I have not downloaded it yet...:-)

If you are going to use the LSN to get to the UID (given your application does not impersonate and you don't have roles instead of users etc.) you may...

Yah! TravisDBA, I can't agree with you more, it's just plain silly!

Lowell - You don't need to use a trace - your application should be aware of who is...

It would also seem slightly superfluous to use the WITH CHANGE_TRACKING_CONTEXT(context) because you would have to supply the context parameter (from the application). If you were anticipating a quick...

To track the "who" and "what" (using CDC) you should add (for example) columns to your monitored tables that provide details on who changed the record and what application for...

Quite correct, we tend to “pluck the pond from under the duck”:-P or better “go on a wild goose chase” when confronted with DB performance problems, instead of pondering the...

I haven't worked with this for a while, but you need to ensure that you have SQL 2005 installed, inclusive of Analysis Services/ Reporting Services on the same machine as...

Nice technology, however one will have to consider several things and specifically the impact on temdb carefully.

For understanding SQL Server locking, Erland Sommarskog has a great script: Download now, that...