yea...why would you do that?

Maintenance plans are the way to go here buddy

Whats the reason behind wanting to drop them all?

Cheers,

Carlton..

I figured, SQL will throw msgs like this if the runtime account doesn't have permission to the location/share that its looking for.

Cheers,

Carlton..

Nope, theres many ways to check but just try connecting to it using Management Studio or RS config tool or checking in control panel.

cheers,

Carlton..

Just deploy them to the new box via VS.

Heres the MS rabble about the DB's

http://msdn.microsoft.com/en-us/library/ms156421.aspx

Cheers,

Carlton..

Does the SQL runtime account have access to E drive?

try creating a test DB on E drive and see if the query gives you an error.

cheers,

Carlton..

yup your right. Have you run a trace on the server while its going?

it may not tell you but it may provide you with some info.

it screams permissions to me,...

see if you can figure out what account the backup software is running under (could be 'NT Authority\system' which is commoly disabled or removed for security reasons).

My guess would be...

Hi, you could but you wouldn't.

search books online for:

"Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views"

I'm guessing sys.altfiles is now only accessible by sysadmins...

Hi all,

I have been given the task of upgrading a bunch of MSDE databases to 2005 standard edition.

The install will be used to manage MS ISA Server logs.

There is...

when you say 'files' you mean the DB files themselves? (DBname.mdf, DBname.ldf).

My pref is to set security @ the MSSQL directory (for 2005 this is: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL) and...

hi,

sorry.

If you using sql 2005?

If so go to the database > Views > System Views > and fild sys.sysaltfiles

If your using sql 2000 its a system table not a...

find the sys.sysaltfiles then

:right click > properties > permissions

chances are there will be nothing. I can't remember what roles other than sysadmin have access by default.

this what u were after?

cheers

Carlton..

Very well put on the tree falling in the woods comment, in my experience triggers appear to go by rows affected but also by statements in the execution i.e. if...

I looked at this as more of a which one performs better question rather than the nature of the operation hence I chose 1.

I guess the absence of a transactin...