Viewing 15 posts - 8,401 through 8,415 (of 9,253 total)
drop the auto created stats from the sql2000 prod database, otherwise each time you restore that db the corrupted object will still be there,
does this make sense
February 19, 2009 at 4:41 pm
Kendal i too, did notice the graphs were a little off but paid more attention to the actual numbers
February 19, 2009 at 4:38 pm
Matt Klein (2/19/2009)
February 19, 2009 at 4:36 pm
either backup and restore or detach and attach to the new server. Script off the login if possible or create a new server login on the sql 2005 server and...
February 19, 2009 at 3:17 pm
depends what you're going to need. Windows 2003 Std x64 bit is limited to 32GB RAM and 4 cpus.
February 19, 2009 at 3:11 pm
1434 udp is only required if not connecting to the named instance directly and usually if the instance is using the non standard port 1433
February 19, 2009 at 2:59 pm
are all the datafiles in separate filegroups?
February 19, 2009 at 11:31 am
Great blog Kendal (you have way too much time on your hands 😀 )
very informative
February 19, 2009 at 11:19 am
Jack Corbett (2/18/2009)
you could restrict the query to only access the most current file which would reduce impact.
filter out tempdb objects too
February 18, 2009 at 2:50 pm
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...
February 18, 2009 at 11:36 am
Jack
did you mean to specify column I.StartTime twice?
February 18, 2009 at 10:10 am
works for me, double check what you copied and pasted
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...
February 18, 2009 at 9:55 am
dude
substitute
exec sp_ExecuteSql @sqlstr
for
Print @sqlstr
and post the output
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?
February 18, 2009 at 7:02 am
Viewing 15 posts - 8,401 through 8,415 (of 9,253 total)