Hi

Do you have any details of the existing .MDF file and .LDF file - do these still exist? or have these been overwritten?

Does it seem like your original .MDF file...

Hi

Steps I would take to trouble-shoot:

1) Check SQL Error log - there may be a entry stating that the log file drive went missing or similar.

2) Do you have a...

I have tested by - taking a 2000 DB - restoring to 2005 and then trying to take it back - and this is the error message:

The backed-up database has...

As far as I understand it - if it is in 80 mode - then the structure of the Database is still 2000 compatible. Meaning that the DB has not...

Hi

I have made use of MSDE and now SQL Express 2005 for an application, some details:

* Size of Databases between 30 - 150MB - yes MB

* ...

Great to hear that all is working fine.

Yes - something strange seemed to be happening when changind or editing security rights for that user.

Kevin

If you are doing the deletes from Management Studio - then yes check triggers or so.

If it is from an application - maybe there is some business logic that adds...

Are you able to re-create the user?

Hi - I have tested this in my environment and used the following steps:

Step 1: logged onto the SQL Server - in EM I expanded security under servername or (local)

Step...

Hi

I would after having downloaded the SP1 or SP2 - then on the PC / Server that requires the Service Pack to be installed - run the package - usually...

Hi

I had a similar problem on my development notebook - which started doing this after I installed SQL 2008 CTP Feb 2008.

I could not open tables or design tables -...

Have a look at the security between these servers, the service account that starts up the SQL Agent Service in particular.

let us know what details you have around this

Thanks

Kevin

This looks like a SQL 2000 Maintenance Plan script - the new 2005 Maintenance Plans make use of packages and usually look like the folowing:

/SQL "Maintenance Plans\UserDBs" /SERVER SQLSERVER ...

What version of SQL Management Studio do you have? - have you run any Service Pack updates to your Management Studio or SQL 2005?

let us know - thanks

Thanks for the article - it is to the point and focused.

It made me think of the components of SQL that I have installed and know that I do not...