Viewing 15 posts - 8,401 through 8,415 (of 9,241 total)
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
could be you cannot resolve the hostname have you tried using the IP address
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 1:22 pm
one way is to create a database user that is not mapped to a sql login but has alter permissions on the tables to truncate. When the devs execute use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 1:12 pm
Jackal (2/13/2009)
Q:\ Quorum
is this a clustered sql set up then?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2009 at 1:09 pm
Viewing 15 posts - 8,401 through 8,415 (of 9,241 total)