You are right. Script out the jobs and then add them back after the rebuild.

Use the Rebuild Wizard (Rebuildm.exe), located in the \Program Files\Microsoft SQL Server\80\Tools\BINN directory. This can be used to pick a new collation. In any case you still...

I have to agree the third statement just produces the wrong value. The 2nd is closest although it should divide by 365.25 rather than 365 but the difference between...

After installing SP2 take a look at http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

These Performance reports are very nice

As long as the defrag software can handle the file being allocated to SQL (it must defrag via the Windows API) then there is no problem. I have been...

It shouldnt matter whether the database was detached to begin with. Do you see the database in Management Studio (EM)? If so get rid of it then...

Of course I want SP3 for 2005. There have been way too many HF released and they need to be rolled up into a SP.

Although it is very interesting to have a 'vanilla' database with no rows in all the tables, if you are doing this just to restore from somewhere else it is...

First select * from sysdatabases where name = 'model'

If this returns a NULL for the SID then try

sp_configure 'allow updates', 1

reconfigure with override

update sysdatabases

set sid = 0x01

where...

They look the same to me. The join between CLMASTER and CLCOLLBAL is an inner Join since you are joining on specific columns being equal and the Join...

look at the script http://www.sqlservercentral.com/scripts/Miscellaneous/61368/

as a tool that may help you. If the collation on a particular database is wrong it doesn't imply that all the tables...

Nice code

I think the messages like you describe show up in the errors collection as opposed to the resultset. . Errors can be generated by a method call or...

Just want to make sure you are refreshing your EM or MS screen. Right click on the database after the restore says it finished and select refresh. If...

Be careful with the growth rate. Growth 1MB at a time is a very small amount. Each time more than 1 mb is added the file will grow...

Wow good post Andras, we must have been typing our reply simultaneously

Great Minds think alike

or is it Fools don't differ

I can never remember those aphorisms

😛