I had to change versions once from Standard to Enterprise, and the only method I found was uninstall / re-install.  The exact method you use to put your databases back is...

My company has 7 SQL Server developers and 1 DBA.  We have about 80 databases, but half of the applications are purchased so the developers only work on the other...

The budget has already been spent so I have to work with what I have.  I don't think the double server log shipping idea will quite fit the bill since...

I actually got the idea to use the standby database for reporting from BOL "Using Standby Servers" that says

In standby mode, the database is available for read-only operations, such as...

For anyone who may be interested, I found the problem.  There is a MS article # 839405 called "You may receive an access violation exception when you try to use...

Thank you.  Actually I found that same article in my "archives" (folder stuff 🙂 because the error occurred last year on another server, but it mysteriously cleared up.  I'm going to check with...

I've seen "not enough storage" errors regarding memory issues and linked servers.  Are there additional errors in the NT logs?  Has the DTS package been working and stopped all of...

Good question.  I started reading KB 262617 and went down a rabbit trail of other articles regarding known issues, interoperability issues, attachments, etc. and at this point am going to leave...

Under Replication Monitor Agents folder click on the Log Reader Agents folder then double-click the agent in the right window.  Is there a better message there?  If not, click Session Details.  It...

I have had Outlook 2000 client set up on two Windows 2003 servers for a few months now (using Exchange) and SQL Mail has been working fine.  It's even running on...

This is just what I need, thank you.  Clustering is new here and I wanted to avoid any possibility of corrupting it again.  It's already been installed twice....  The second time...

You don't necessarily need a format file, just double-quotes around the pipe:

EXECUTE master..xp_cmdshell 'BCP pubs..authors out C:\authors.txt /c /Sservername /T -n -t "|" '

I've gotten the error before when BCP...

Thanks for the info, but I found the problem.  Under 'Configure Publishers, Subscribing, Distribution' then the Publishers Tab I hit the ellipsis button for 'distribution' and found where the sa...

We have a linked server to a DB2/As400 using an ODBC and can pull data fine.  Never tried a push, but it probably depends on the driver.  We also us...

Great!  This is exactly what I was looking for.  Thank you.

Linda