We appear to have a high number of page faults.  Could mssearch (full text search) be causing this?

It is 3rd party product, quite popular as an alternative too xp_sendmail as it can send HTML mail.

See http://sqldev.net/xp/sp_smtp_sendmail.htm

That's what we have currently, and that is what my boss wants to move away from - i.e. hard-coding the tags.  He is looking for something generic where he can...

I'm afraid cmdshell results in the same problem.  The 'chopping off' is an ODBC limitation.

David:  Thanks very much for confirming that!  I was beginning to suspect the same!

We are using the FOR XML clause and sp_makewebtask, but have encountered that problem where if the...

If you are going to encrypt your databases, don't forget to look at your front-end and reporting systems as well.  Not much good to encrypt sensitive data on your database,...

Is that Visual Studio.NET or Visual Studio 6?

BOL is 'Books Online', the help files that comes with SQL Server.

Index the SQL view and see what happens.  When you index a view, SQL Server creates virtual tables that contain a copy of the data in the base tables.  When you...

Just thought of something.  Why don't you set up views for each table, use the views to convert your datetime data into char data and use the ExportData method on...

I looked in BOL and couldn't find anything where you could use DMO to reformat your datetime data.  Maybe using a format file would work, but I didn't see anything...

You can use dynamic SQL like this:

DECLARE

   @TABNAME VARCHAR(30),

   @COLNAME VARCHAR(30),

   @COL2 VARCHAR(30),

   @sql VARCHAR(4000)

BEGIN

      SET @TABNAME = 'Table1'

      SET @COLNAME = 'Col1'

      SET @COL2 = 'Col2'

      SET...

SET XACT_ABORT will rollback all your previous deletes as well, even rows that you want to delete - so that won't work.

I don't think ANSI_WARNINGS will work either.

I would expect using BatchID...

You can use DTS (Data Transformation Services), which is part of SQL Server.  Using Enterprise Manager, navigate to the database you need to export from and click menu option: Tools/Data...

Also, if you are using mapped drives then make sure that the server has the same drive mappings.