A book that covers the basics very well is SQL Server 2000 DBA Survival Guide. Most books don't cover DTS or ActiveX scripting in much detail though. You...

sysmessages only contains the generic error message, without references to the particular objects.

For example: Unclosed quote before the character string %.*ls.

Is that specific enough?

Thanks Greg. What version of Oracle are you working with?

I am planning on taking some online courses from Oracle University. That should help me get started.

Do you have...

This should be possible using linked servers. The downside however is that if the second server is unreachable, the whole transaction will fail.

Maybe someone knows of a workaround?

David,

I found this link that might be of interest to you:

http://webdevelopment.developersnetwork.com/Articles.asp?Article=227

The suggested route is to make another device the default device and then switch the tempdb to RAM...

Very similar to David's suggestion:

1. Put the data in a temporary table. 2. Join the tables and update the matching records in the destination table. 3. Join the...

Are you running the Standard or Enterprise edition of SQL Server? The Standard edition cannot use more than 2GB.

JM

If all you want is to be notified when the log reaches a certain size, you can create an alert based on a SQL Server performance condition. (SQLServer:Databases - Percent...

Did you detach the original files from SQL Server first? Here is what BOL says:

sp_attach_db should only be executed on databases that were previously detached from the database server...

If your servers are not part of a domain, you might need to create the same account on both of them. That way, loging in to the remote computer...

Typically you detach the database physical files (.mdf and .ldf) to move a database elsewhere. You then attach them in SQL Server to create a new database.

In your case,...

Make sure that you don't over-allocate memory, so set your min-max SQL Server memory settings accordingly for each instance.

Personally, I don't see much benefit from using several instances on the...

Can you post the error message you are getting?

JM

The file is a MMC snap-in (.msc extension).

The file is called 'SQL Server Enterprise Manager.MSC' and is located in the \Binn folder of your MSSQL installation (client or server).

Hope this...

Hmmm...I tested it in Query Analyser and it works. Did you type it all on one line in osql?

What version of SQL Server are you using?

Jean