Did you try restarting the SQL instance before running the script Pavan?

For the script to take effect you have to restart the instance anyway, but hopefully you tried a restart...

Even in 'simple recovery' mode you can get the tlog of a database running out of space, incl for tempdb. SQL Server makes heavy use of tlogs internally, exclusive of...

Simon...in defence of 123DBA, if you follow 123DBA's script you will see that he does print at the end of the run a message saying to now do a full...

Hi Pavan,

If you're still having issues, following what wangkhar has suggested, you could try moving tempdb with the following to see if this helps

use tempdb

go

EXEC dbo

Hi Paul,

We always lock away the sa account with a strong password and leave it disabled (even us DBAs don't use it, except for emergencies). We then use Windows accounts so that...

Hi Jai,

You might want to have a look at the following link, it may help  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55519

Things to consider are:

1. Is it the right SQL Server version you're trying to...

Best way (IMHO), if you can, is to have all access to tables via stored procs, whether SELECT, UPDATE, INSERT, or DELETE. This way no-one has access to the physical tables....

We're luckly...because, quite simply, we put very strong pwds on our sa accounts and lock them down, i.e. don't use them (also, only the DBAs have access to the pwds)....

Noel...you might want to take a look at this article from Slav Oks's weblog http://blogs.msdn.com/slavao/archive/2005/04/29/413425.aspx.  This is where I originally got the info that using AWE on 64-bit is...

No problem John. IMHO thats how we all learn. I've got it wrong before and I'm sure I will again (and may even have now). Its good to have people...

Sorry Steve, but I'm not reading the article like that...

As from  http://www.sqlservercentral.com/columnists/rpearl/abitabout64bit.asp, Robert Pearl says...

'...Indeed, while 32-bit scalability scales well in most large transaction and data warehousing applications in...

In my experience, Clifford is spot-on. Good advice.

Sorry Dan, don't know the answer to you question, but, thought you didn't need to use /PAE and /3GB for 64-bit OS and SQL John? Certainly you don't for 64-bit...

Jubilee,

You've got your tlog sitting on the same drive that your second (default) data file. This isn't a good idea as I guess there will be a lot of disk...

Ahhh, sorry amira, misread the bit where you mention '...DBA asking for this...'

Alway a tetchy subject on who has control on what area of the systems setup - and I...