Working from home is something I covet even though I only get to do it once a week.  Lately I have had to work every day because another person in...

Cory,

  Do you remember exactly what the error said when trying to register the 2005 server?

I'm not sure why you say you cannot replicate 2000 to 2005.  This is a direct quote from that article:

Using a SQL Server 2005 Distributor with a Publisher Running...

Actually when I monitor it on the server it shows a scale of 1 and it is in the proper range. This is just opening up Performance Monitor and it...

The space that you use for the reindexing will just become part of the free space when you look at your database after the reindexing.  If you observe your used...

The first time that I tried reindexing all of my tables in SQL2000 I ran into the exact same issue.  I just had to keep expanding the database until it...

Greg,

  To change the account that the SQLServer Agent runs under I'm pretty sure I have to stop the service, change the startup options to use a Domain Account, then...

Greg,

  The service runs under the Local System account. Would there be a need to have it start under a different account and assign permissions to that account?

I think you constantly have to prove that your backups work and the way we do that here is to constantly restore our production backups to our test environment.  It...

Frank,

  I already took that class about 3 months ago in anticipation of moving to SQL2000.  If you can start looking into DTS (Data Transformation Services) it is a very...

Frank,

  My role over the past few years has kind ov 'evolved' into a DBA role.  I am certified as an MCP in SQL 7 administration but haven't gone as...

I liked the article but wanted to read more.  In the role of database administrator at my work this involves not only making sure that the data is recoverable but...

Thanks for the info...

I'm not sure what you mean.  They look fine when I view them.

Regards,

Thanks Andy for the help..

Regards,

Bessebo