Viewing 15 posts - 1 through 15 (of 28 total)
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...
February 3, 2017 at 11:55 am
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.
June 21, 2012 at 7:02 am
Sorry by 3rd week of the month I meant 3rd friday of the month!! 🙂 Guilty as charged!
February 17, 2011 at 4:46 pm
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...
February 17, 2011 at 2:22 pm
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...
February 17, 2011 at 1:35 pm
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...
February 17, 2011 at 1:17 pm
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...
February 17, 2011 at 12:52 pm
Glad you like it!
July 22, 2010 at 9:27 am
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...
February 3, 2010 at 8:38 am
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...
January 6, 2010 at 10:32 am
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...
January 6, 2010 at 6:41 am
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...
October 30, 2009 at 6:23 am
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....
October 24, 2009 at 7:56 am
BTW there is no Looping in this script..
CREATE PROCEDURE dbo.procname
SET NOCOUNT ON
SELECT * INTO #diffs
SELECT * FROM [db2].dbo.tableB
IF @@ROWCOUNT = 0
October 23, 2009 at 8:41 pm
Not sure if this will help but try running this query... It will show you pages allocated for some system objects as well. Also sum up the MBs_Used column...
October 23, 2009 at 6:48 am