if i m correct unc means uniform naming convetion. i.e. the fully qualified name (servername.domainname.extention)  and a path on that server.

e.g \\yourserver.yourdomain.com\yourshare\...

If the serviceaccount has been granted the right...

...80004005 ... when EUSC004665\SYSTEM runs the package it has no access to the file you've specified. Provide EUSC004665\SYSTEM the authority to go to the folder where you've put the...

indeed, by default a PK will be a clustering index, unless there is already a clustering index active, or if you create it nonclustered.

create table mytb (col1 int not null...

In addition to this nice article, I also enjoyed Laurentiu Cristofor's blog at http://blogs.msdn.com/lcris/

- also keep in mind, you'll have to grant exec-rights for the storedprocs and functions.

- probably developers will just end up using the overauthorized user unless you change it's password...

.. multiple-to-multiple ..

indeed, it's best to avoid duplicates, so at least a unique constraint may be advisable. If it should be a primary...

There is ofcourse the classic literature :

Using CLR Integration in SQL Server 2005 (http://msdn2.microsoft.com/en-us/library/ms345136.aspx)

http://www.programmersheaven.com/2/SQL-server-2005-school-lesson-6

...found that user for those dts packages is restored also...

What do you mean with this ?

- Do you mean a userid used with the connection(s) ?

     In that case...

- maybe all he wants is a fast logging-kind of table.

(pumping it away to another server for querying/investigating and providing it with...

for this kind of errors, I'd always start with launching

dbcc checdb ( 'database_name' )   WITH ALL_ERRORMSGS 

and work from there on.

(check BOL)

to Noeld ..

About the restore of a db at another server, you can reanable automatic key management for the db using the old dbpassword :

if not exists ( select MKP.*

     ,...

here's a good article about awe.

www.sql-server-performance.com/awe_memory.asp

You're completely correct.

I actualy wanted to point to SET XACT_ABORT  ON

This should stop the execution when the first error occurs within a batch...

Antivirus software performing a systemscan at that timeframe ?

We've had some problems using a filebackup software (veritas) that was copying our .bak files at the moment that our backup job started to run.

Because of the folderlock the backupsoftware...