Interesting find!

I had instrumented the code below to run nightly benchmarks across a large farm of SQL Servers honestly to keep an eye on our infrastructure teams and any changes...

I'm not sure if this will help but the issue you're describing reminds me of what happens when you exhaust the non interactive desktop heap in windows.  Once that happens...

Hi,

I just encountered the same issue and I believe the way to escape the quote within the -q or -Q is to double up the quotes.

So...

Sorry by 3rd week of the month I meant 3rd friday of the month!! 🙂 Guilty as charged!

I agree with Jeffrey and in addition there are a few things you should consider before you reboot and this list is by no means inclusive of everything to think...

You can build plenty of logic into triggers but in my opinion its never a good place to define business logic. What you're attempting to do should really be...

You should be able to accomplish what you want by using a CASE statement. Psuedocode as follows.

SELECT CASE WHEN current_timestamp > (your 3rd FRIDAY of month calculation)

THEN (altered 3rd...

Without more information it is a little difficult to answer your question but with some modifications to the code below you should be able to figure it out. The...

Glad you like it!

Enjoy!

It looks like you have node 1 running the SP3 CU3 Binaries

and node 2 running SP3 CU3 + a QFE hotfix (KB970894)

You don't want your nodes to have different...

Try This...

IT is written ASSUMING your reporting services database is named REPORTSERVER

and its COLLATION for the name column in the catalog table is Latin1_General_CI_AS_KS_WS

Let me know if...

liebesiech thank you for getting that fixed for me. For some reason when I submitted it to SQLServerCentral the control they use for the submission seems to have taken...

I really hate writing dynamic sql that takes a table name in for a parameter for sql injection and query plan reasons but I figured this would be the easiest...

UPDATE tB

SET Source = DIFF.source

, number = DIFF.number

This is part of the update statement and it's actually setting the number in table B equal to the number column in #DIFF....

BTW there is no Looping in this script..

CREATE PROCEDURE dbo.procname

as

BEGIN

SET NOCOUNT ON

SELECT * INTO #diffs

FROM [db1].dbo.tableA

EXCEPT

SELECT * FROM [db2].dbo.tableB

IF @@ROWCOUNT = 0

...