Viewing 15 posts - 8,401 through 8,415 (of 9,244 total)
Mike Levan (2/18/2009)
If you want notifications you can do the DDL triggers or you could do a job that queries the default trace on a regular basis which sends you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 11:36 am
Jack
did you mean to specify column I.StartTime twice?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 10:10 am
works for me, double check what you copied and pasted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 10:05 am
Magy
sounds like the best advice is check what machine backup software you currently use. Check if there is an open file agent, if so trawl through your recent tapes looking...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 9:55 am
dude
substitute
exec sp_ExecuteSql @sqlstr
for
Print @sqlstr
and post the output
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 7:05 am
at a guess your login credentials dont allow you to install the software, group\local policy in force maybe?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 7:02 am
the most complex part of the system is getting the cluster and its resouces in place, the rest is plain sailing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 6:08 am
ALZDBA (2/18/2009)
1) restore the db to SQL2005
2) DBCC for DATA_PURITY
3) switch to dblevel 90 (if possible)
4) rebuild all indexes (individually)
5) dbcc updateusage with count_rows
6) sp_updatestats
7) synchronize users
8)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 2:46 am
Ewan Hampson (2/18/2009)
Perry Whittle (2/17/2009)
select serverproperty('edition')'edition' only seems to return eg "Enterprise Edition", nothing about processor. Though I don't have 64-bit to see if that's any different.
run it on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 2:38 am
select serverproperty('edition')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2009 at 9:52 am
Jeff Moden (2/15/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2009 at 1:29 pm
Ninja's_RGR'us (2/15/2009)
Hey Darth. stop reading my freaking mind!!!or is it the other way around :D.
i find your lack of faith most disturbing ....... LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2009 at 6:54 am
Ninja's_RGR'us (2/15/2009)
since showing 10M records to the users is quite useless (from my humble experience).
my thoughts exactly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2009 at 2:25 pm
you are trying to insert a varbinary value into a dynamic sql string.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 3:25 pm
Ninja's_RGR'us (2/13/2009)
That reminds me of those 2 procs... hoping you don't need to use them anytime soon :exec sp_update_resume
exec sp_distribute_resume
😀 got a feeling he'll be using those anytime now.
Ninja's_RGR'us...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 1:30 pm
Viewing 15 posts - 8,401 through 8,415 (of 9,244 total)