You can try a switch like -s"" to reduce the column separator to nothing, which will remove the leading space, but the consequence of this is that no separator will...

From the xp_smtp site (http://sqldev.net/xp/xpsmtp.htm)....

Note: SQL Server 7.0 and Windows NT 4.0 usage

When using SQL Server 7.0 on Windows NT 4.0, you need to install...

A cool feature would be "free to all sqlservercentral members".

select replace(name, 'Pack of', 'Case of')

FROM         dbo.PRODUCT

WHERE     (NAME LIKE '%pack of%')

If using Profiler you may want to start with monitoring "Log File Auto Grow" (and use the filter to restrict monitoring to the database in question).

Once you've narrowed down WHEN...

Martin,

A detach/attach will create a shiny new transaction log file.  I'm assuming here that you have just one data (mdf) and one transaction log (ldf) file for this database.

To be...

...and my newsletter says that yesterday's question was... "Which of the following is not a phase in DTS' multiphase data pump...".  Was it??

alzdba, you're not alone.  someone's answering my questions for me too.... AND doing it rather badly.

Brent,

I suggest you test the integrity of those files in your data folder:

a) install sql2000 on another machine

b) copy the mdf files relating to your user databases (ie....

I *usually* find it's a 50%-ish split.  If you want some control over the % (eg. 40%/60%) you may have to backup to 5 files (2 on one device and 3...

Just use 2 destinations in your BACKUP command.  eg.

BACKUP DATABASE mydb TO DISK = 'G:\mssql\backup\mydb1.bak, DISK = 'H:\mssql\backup\mydb2.bak' with init

Only one of the paths will be taken.  If it meets criteria#1 then it will not be tested for any others.

Note: your CASE excludes an ELSE, therefore Field1 will be...

if you're using EM on the actual SQL2000 server on which you've installed, try the registration with "from now on let's do this without the wizard", type in the server...

No, SQL2000 spoilt us with its ALTER...SET...WITH ROLLBACK IMMEDIATE|AFTER

In SQL 7 you have to KILL everyone using the database and then do the sp_dboption.

BOL 7.0 confirms that the sysdatabases.status column...

It's preferable that they go on physically separate disk arrays, on a separate channel or even better, a separate controller.  Logical partitioning really does nothing in terms of performance or...