The following will produce the desired results without the the need for a loop.  It works on your example record set, but I'm not sure if it's what you want...

Tim,

a couple of questions:

1) what i sthe error msg you get from the log shipping restore?

2) is the DTS export just a straight export or are there other bits?  To...

TempDB is re-created when you start SQL, which is why you lose the users and privileges.

You can add them to model with the required privilege, therefore the creation of tempdb...

Keith,

INSERT... SELECT is not minimally logged, but SELECT... INTO is.

If your migration strategy allows, see what results you get from say:

SELECT columns|*

INTO target /* must not already exist */

FROM...

Can you post your code?

  Phew!  I thought it was just me.

Fredy,

xp_cmdshell isn't the only way to go.  Among a probable multitude of methods there's probably WRITETEXT and UPDATETEXT that could be used in conjunction with OLE automation and the filesystemobject methods. ...

I've previously done this in a rather over-complicated way of using xp_cmdshell to determine where the "textcopy.exe" was located and then using xp_cmdshell again to invoke it to do the...

How about:

select distinct s1.Person,

    [Item #1]=s1.[Item #]  ,

    [Item Description 1]=s1.[Item Description]  ,

    [Item #2]=s2.[Item #]  ,

    [Item Description 2]=s2.[Item Description] 

from sales s1

join sales s2 on s1.person =...

Duncan,

I'm sorry to say I tried everything you did, substituting tempdb for Duncan_test , and it worked fine.

Are there any special attributes/options associated with the SQL2000 version of Duncan_Test that...

What is the error you get?

Glad we sorted that out before you got frustrated and tried out the "format" command.

Technically speaking, you're right Brent.  And the 50+% of people who chose the "correct" answer are wrong (oops, that includes me :crazy.

I think we tend to...

You are looking in the SQL Server's C:\WINNT\system32 directory, and not your own local C:\WINNT\system32, right?

Jim,

Now that you mention the 3rd party monitor, I have previously experienced a HP monitoring system that took over control of the errorlog in a similar fashion.  I think at the time...