Actually parsing SQL is quite a simple thing, once you find the right .Net class

Here is one example of what you can do ..

http://tsqlsmells.codeplex.com/

Should be a relatively simple thing to...

This sounds like a relational division problem,ie some rows, equal rows, more rows...

Joe Celko has done a good write up on the subject, http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the-sql-of-relational-division/

rohaandba (10/11/2012)

As mentioned this Trigger doen't not allow developers with DDL-Admin permissions and Db Owner permissions to make any DDL changes to the Databases

Is there any way I can allow...

Sounds like you need a 'catch-all' query

Try this post :http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

IF you show your code for the solution and the execution plan then you may get some suggestions on optimization.

Blurgh, sick in my mouth a little.

Im no sql purist by any means, but this *cant* work. ie relying on top 100 percent to order ,(at least in the long...

True, maybe im thinking of snapshots then, have to be out of the database to rollback to a snaphot.

Complete pita 😉

Done the same sort of thing, but when there are apps that fire continously then they can get the single user connection .

Had to re-sort to pausing the service 🙂

http://blog.sqlauthority.com/2012/09/20/sql-server-2-t-sql-puzzles-and-win-usd-50-worth-amazon-gift-card-and-25-other-prizes/[/url]

Quick, $50 for the correct answer 🙂

So...

WHERE [Product Date] >='20120811' and [Product Date] <'20120819'

will do you, you dont need to ignore the time, just adjust the search arguments to match your data

Try a 'manual pivot' like i show in this article http://www.sqlservercentral.com/articles/T-SQL/73887/[/url]

Sounds like a table valued parameter is your friend here.

When you replicate a view, then it will look to replicate the base data (i believe).

In any case, sounds like an indexed view would be better for your circumstances, ...

Have you tried setting the database to using 'RESTRICTED_USER' then killing off the spids ?

Just thought i'd pimp my powershell script that can auto-detect quite a few of the points that have been discussed here.

http://tsqlsmells.codeplex.com/[/url]

Not saying that the 'code review' process can ever be...