One by one. It backups and deletes the old ones.

What is your database recovery mode when performing Bulk insert?

Just add a little to Brian's reply, TargetServersRole has been denied to run most job related storoed procedures in server pack 3.

Trt Microsoft Visio.

We alreays keep Quorum drive in its own disk. You should also place the transaction log file in separate drive too.

The login has to be granted to access both databases in SQL Server with proper permissions.

"Where do I find/how do I use Enterprise Manager/the Query Analyzer?  I can't find an .exe file anywhere for either of these.  Please help! "

The tools come from SQL Server either standard...

"The production dba did a shrink on the database and got the production table down to ~350MB with ~ 250 MB of indexes. Why is this so much larger? It...

Yes, The user has no permission to select on both tables. And it works as user be granted to select on view and 'DB cross-ownership chaining' is on.

Can't reproduce your problem. Once "allow cross-database ownership chaining" is enabled on both databases and "select" permission be granted to the user, The user can run "select" on the view...

Are both servers in same domain?

For example, EXEC xp_sendmail 'Test', @query = 'exec sp_helpdb exec sp_helplogins'

EXEC xp_sendmail 'test', @query = 'select * from sysdatabases select * from syslogins'

You need configure SQL Server Agent proxy account from Agent property.

Can't reproduce your problem. First script runs successful but received error message by running second script.

"Server: Msg 3902, Level 16, State 1, Line 1

The COMMIT TRANSACTION request has no corresponding...