check for any AWE related Messages at the front of your errorlog. It should work. Check memory SQL is actually using via sysmon, not the task manager.

Follow the instructions for...

you can continue to run your DTS packages if you download Microsoft SQL Server 2005 Backward Compatibility Components from the SQL2008 feature pack at

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

That will allow you to continue...

ok, I'll ask - why do you want all your users (well, three quarters) to have the same password?

what exactly do you mean by script all databases? what information are you after?

very interesting to come to this question late after it was edited. amusing to see an option 'do not pick this' and 22% of people had!

I thought april 1st...

don't beat yourself up, you should have seen one of my posts last week 😉

well edition features appear to be misleading at least about indexed views so cannot be taken as gospel (unfortunately).

I will see what my testing shows.

I do appreciate the interest and...

Jeff, do you have a reference to that, bit of a blow if it is true. This is for a create index, not a rebuild.

cheers

george

cheers kevin

sorry, stupid, stupid post. :blush:

How often will the contents of the master database change? surely not that often so a restore or recreate objects from scripts should not be necessary at all.

Maybe you...

make sure you know why the database is suspect first by checking the errorlog.

USe with norecovery NOT no_truncate to do a tail log backup. norecovery only works if the log...

OK Jeff, thanks.

Thanks Jeff.

I am not familiar with the SPLIT command. do you mean alter table..SWITCH, which would not be available in standard edition.

Hmmm, interesting Jeff, a poor mans partitioned table. It looks as if it would take a fair amount of effort to get to this set up though if it was...