Also should add,

Q: Is XPSMTP supported on a cluster?

A: Yes, you only need to make sure that the binary (xpsmtpXX.dll) is available in the BINN directory of every...

Instead of setting up Outlook or Notes client, install xp_smtp_sendmail from http://www.sqldev.net. This DLL just needs a simple smtp mailserver address to handle emailing from SQL Server.

A big benefit is...

Steve

For your basic output needs, I'd take a look a creating a stored procedure that provides the output in the correct layout. Then just use the OSQL command line tool...

The cost value percentage will just highlight which part of the query takes the most time/resources. You really need to look at the number of reads (logical and physical) being...

I thought it was just the SQL Server performance counters that were stored in sysperfinfo

If the flat files are for data transfer purposes then DTS is your tool. For really, really basic text file output you can use the OSQL command-line utility.

If a report...

Not sure about a single query to list all pinned tables. Maybe one of the DBCC commands that shows chace usage could help.

To see if individual tables are pinned you...

Not particularly familiar with Oracle and SQL Plus. What is the purpose of the flat files that you're creating?

That would be GRANT REFERENCES.

Are you talking about getting the live, or historical values?

Live performance data can be seen in Windows System Monitor in Administrative Tools.

For historical data, you would need to capture that...

In Visual Studio you can setup different configurations (debug, release, etc...) that point to different servers. You just select the configuration and choose deploy.

What I've come up with is to...

1.  It isn't a "result set" solution which is the biggest complaint I've seen against cursors.

That's right, I wasn't presenting it as a "result set" solution, I was presenting it as...

Where are you backing up the file to? If it's a network location then you could be having networking issues. SQL Server is very, very picky about network connectivity.

Consider this,

DECLARE @id int

SELECT TOP 1 @id = id 
FROM sysobjects 
WHERE xtype='U'
ORDER BY id

PRINT @id

WHILE @id IS NOT NULL
BEGIN
    --do stuff

    SET @id =...

I'm presuming you have an ActiveXScript task like

Function Main()

  DestinationColum("Col001") = Source("Col001")

etc...

If you put the On Error Resume Next statement before the line you want to capture error information for,...