Here we try and name them this way...

SystemCode, Brand for which this applies if you have several companies, environment...

IE :

TMX_ABC_PROD

TMX would be the application or package

ABC is the company or...

A reboot did the trick. Something so simple wow !  Thx !

No I have not. Do you think I have to ?  When I installed the Oracle client it did not ask to reboot.

  I have heard it said that Microsoft wants to get to a point where they have a new release every two years of SQL Server. As a DBA with...

I know when you take a SS2000 database and restore it into SQL2005 it keeps it in SQL 2000 compatibility mode. You have to physically change it to SQL 2005...

My IT Career started as a Data Entry operator in 1985, became the Computer Room Tape librarian, then got promoted into the database group as our Infopac/Document Direct Online Report...

OK, I opened a ticket with Microsoft on this issue. I simply took CD #1, copied it to the server and ran setup.exe. works fine for db server. The CD's...

 Slap my hand. I should know better. I thought that in the maint plans the middle section that states write history to table and you can keep that to a...

In one shape or form I have been in front of a CRT/Monitor since 1985. My eye sight has gone down hill ever sense. About 3 years ago I started...

Thanks. I have found the runtime is tied to the # of months and especially the # of databases / # of times a day you run full and trans....

For anyone that is interested...

sp_delete_backuphistory 09/01/05

Am I missing something here...

If you have auto stats turned on then really you do NOT need to run a manual process to update the stats..... that is what the...

OK, I understand why you do it that way then...

I assume you have the auto stats turned off on the database since it is so large then ?

I have...

Maybe I am missing something but why don't you just use the maintance plan wizard for the stats? I have used it for four years on all of our databases...

Here we are a very busy shop. However, our bosses are somewhat relaxed in letting us take comp. time when we have worked alot of hours over 40 in a...