Viewing 15 posts - 2,176 through 2,190 (of 7,498 total)
chances are you we reading my previous reply at the time I edited it.
Did you have a look in the cluster service log file ?
March 29, 2011 at 8:09 am
can you provide OS info ?
Clustering is one of the things that has been "enhanced" vastly with the differen os versions
Did you have a look in the cluster service log...
March 29, 2011 at 8:02 am
yet another alternative ... raise an error that is being captured by sqlagent.
http://www.sqlservercentral.com/scripts/Miscellaneous/31032/
If you're not comfortable with the sqlengine you are using, don't go for the service broker solution;
If it...
March 29, 2011 at 7:56 am
GSquared (3/29/2011)
If your actual data is much larger than this, you might get a performance improvement by adding a piece to the Where clause that limits it to only updating...
March 29, 2011 at 7:47 am
that's what an outer join is all about.
In your case I would use a left join. It will return NULLS for its column values for the non-matching rows
I see...
March 29, 2011 at 7:33 am
there must be some trigger / notification service capturing your action and reverting it.
March 29, 2011 at 7:20 am
did the provided script match your question ?
March 29, 2011 at 6:22 am
bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Took a shot. 😉
March 29, 2011 at 1:33 am
First shot:
( created a SSC_LVL80 db to mimic sql2000 behaviour )
Only those parents who have one scout with REF_SCT_RANK_ID = 5 will receive the STATUS update of 'INACTIVE'
Is the "one"...
March 29, 2011 at 1:10 am
happycat59 (3/28/2011)
The most likely reason that the XCOPY was failing is because the drive mappings are specific to the user who mapped them. When you use xp_cmdshell, this is...
March 28, 2011 at 11:50 pm
You can find that info using:
use yourdb
SELECT db_name() DatabaseName
...
March 28, 2011 at 5:05 am
Libor Polansky (3/27/2011)
With one table where is just one record.
create table test (test int);
go
insert test select 1;
My question is:
How to completely clear buffer pool (same state...
March 28, 2011 at 12:34 am
Jeff Moden (3/27/2011)
ALZDBA (3/27/2011)
I didn't say it doesn't use model db, I said it doesn't just use model.Which is not the same as "it just doesn't use model".
Ah... my bad....
March 28, 2011 at 12:30 am
Jeff Moden (3/27/2011)
ALZDBA (3/27/2011)
Tempdb doesn't just use model.:w00t:
Ummmm.... not quite right. From the first sentence you find when you lookup "Model Database" in BOL...
The model database is used...
March 27, 2011 at 2:55 pm
Viewing 15 posts - 2,176 through 2,190 (of 7,498 total)