I too have the same issue in my app as we use indexed views.

Solution is to set the connection defaults to ANSI at the server level - which I think...

That article states that via linked servers (ie 4 part name in SQL Server) you can only do selects.  However I am reasonably sure that you can do updates, inserts...

I would love to come along!!  But it's a bit of a hike from Australia   Maybe I can ignore customer phone calls for...

I don't really see that this is a trick necessarily.  From a general SQL backup point of view (not just diff backups) you should be aware that SQL can store...

From what I've seen, I think you want something like...

You receive goods - each received shipment has a quantity and a per item cost.

You consume goods - each time you consume...

Please don't cross post.

Someone's answered already in this thread.. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=286419

Makes it hard for others having a similar problem in the future to track down answers by searching the forums...

You could use sp_executesql which at least cleans things up a bit with the quote counting..

Also, you can insert into a table variable from an exec statement - so the...

The more tightly defined scope allows SQL to possibly make better judgements about the state of the table - hence less recompiles in stored procs.  Table variables, being tightly scoped,...

Your guru seems self proclaimed.  I doubt there's any significant benefit - real or imagined - by using the tempdb.dbo. syntax.  You also lose all of the benefits of temp...

I haven't tried it but I had heard that you can simply delete the text of the stored proc from the syscomments table.  Thus the compiled version is still there...

It certainly sounds like you need to index your data a bit more to at least allow each report to avoid table scans - this should reduce contention.  The indexed...

The other thing is that there will be hundreds of other ppl who will be in the same situation as you found yourself in (whatever that was).  If you left...

So I understand that you want to have a table that contains a persistent view of your data.  I would expect that your client-side app can work with views, but...

If it's just doing SQL Server work then give it the /3GB switch in boot.ini to let SQL use 3GB of RAM leaving 1GB for the OS.  If you have...

The datetime type is designed to store a point in time - it is not designed to necessarily store a duration unless you base that duration from time dot