steve, thanks. we have a full blown change management system here (RMS) so all documented and approved.

george

crever,

ta

Marios Philippopoulos (6/3/2008)

---

GilaMonster (6/3/2008)

---

Nope. Even under 16GB you risk starving the kernal of memory.

Personally...

have you tried sp_helptext. with view definition rights should work

avipenina (6/3/2008)

---

THX.

so if i understand right if i have 32BIT system with 4GB box mem only enable the /3GB switch?

if i only enable the /3GB switch on 32BIT with 4GB...

GilaMonster (6/3/2008)

---

It should be an either-or.

As soon as you enable /3GB, you're restricting the kernal to only 1 GB of memory. That's all it gets to run the core of...

visit the scripts site on this forum. There are lots of scripts to kill connections based on some criteria such as dbid. amend one of them to suit your needs....

If you only have 4GB of memory installed in your server do not enable AWE. AWE is for memory above 4GB. Leave as is with the /3GB switch enabled.

I've remembered what happened the last time I hit this error.

the server had been taken out and back into the domain but not cleanly, leaving a rogue entry for the...

the enclosed article should help:

http://support.microsoft.com/kb/811889

I am struggling to remember the details but I have had this problem before and it was linked to the server having dropped out of the...

your new setup is better.

autoshrink is best left off because the constant growing and shrinking wastes resources and fragments the physical file.

If the tran log is in simple mode set...

......and if doing this type of process good to do a backup just before just in case..............:)

will it start in default mode - sqlservr.exe -f -s ?

if so follow http://www.tek-tips.com/viewthread.cfm?qid=798602

else do you by any chance have a copy of the original master .mdf and...

a shrink of the log file can only shrink down to the last used virtual log file. Use command 'dbcc loginfo(dbname)' to find the last used (they have a status...

are the databases the same size, containing the same data, Stats up to date, database fragmented? Indexes missing, different? Network bandwidth the same? configuration values all the same? AV?