Manoj

That sounds OK.

John

Manoj

You should start a new thread for this question since otherwise it will only be read by people who are watching the original topic.

John

Ron

Since Kathleen has Windows Server 2003, it is true that she can use the /3GB switch in her boot.ini file.  This will allow certain applications to access 3GB of RAM...

If I have understood your requirements correctly, you should still be able to script out the database creation (tables, SPs, constraints, views and so on) into one text file and...

Kathleen

PAE allows your 32-bit processor to access more than the 4GB of address space it would normally be able to see.  However, SQL Standard Edition can still only use up...

Kathleen

SQL Server 2000 Standard Edition can only use up to 2GB of RAM.  If you want to use more, I'm afraid you'll need Enterprise Edition.

John

Prasad

Have you tried using DTS?  Then you wouldn't need to create any scripts at all.  You can transfer all the data in a table to a text file first if...

Louisa

Why would one record overwrite another?  One of two things will happen.  If there is a UNIQUE constraint on process_ID then you will get an error message.  If not, you...

Josh

Different databases can have files with the same logical names.  We have this a lot where we use multiple copies of the same database on the same server for testing. ...

Depending on what services you have running when you apply the service pack, you may or may not have to restart the computer(s).  But if you are doing this six...

You can use performance monitor counters to get a feel for the latency between the publisher and the distribution database, and between the distribution database and the subscribers.  Then you...

Mark

I usually set the log size to what I think will be the maximum needed and then don't let it grow.  I create a job that dumps it when it...

You might also want to look at http://www.sql-server-performance.com.  It goes into quite a bit of depth about performance monitoring.

John

Anthony

The error message suggests that you are trying to insert data into a column that isn't wide enough to take it.  For example, you may be trying to put a...

This is something I've tried before that works.  It's quick and easy and doesn't involve modifying any system tables.  All you do is stop all replication processes, back up the...