As one who has been bitten by "On Error Resum Next" I now eliminate it wherever it's encountered. The following snippet is much better for VBScript error handling

On Error Resume...

In addition to xp_dirtree, you can use xp_getfiledetails to return detailed information about a file or folder.

eg: xp_getfiledetails 'C:\Temp\test.txt'

Firstly, why do you want to turn them off?? Is your log getting to big? If so, why not use sp_cycleerrorlog to create a new log file. You can adjust...

Also, for efficiencies sake, you should specify a column in the SELECT statement.

EG:

WHERE NOT EXISTS (SELECT [your id fields] FROM MAXSYR etc...)

This will prevent the query from spooling up the...

For a far simpler method, check the answer to one of my past posts,

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=100177

Interesting to note that the date the ISO was posted is 21st July, yet there were no official announcements until the 26th.

Does it take 5 days to upload a 600mb...

As you mention, the test from sysmessages isn't that helpful.

Try this interesting technique,

http://www.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp

So where exactly does it fail and what is the error message?

Does it get to the xp_sendmail part?

Don't know which version of SQL you're seeing this in.

DTS Packages are stored as a Binary object in the sysdtspackages table which resides in msdb.

I don't know any method for...

Make the domain account a LOCAL administrator, or specifically grant it access to write to the event log.

There will be a Management Tool for SQL Express 2005 shipping at a later date.

In VB 2005, I believe if you open a new database project you can then create...

You'll need to use a subquery, or derived table.

EG:

SET NOCOUNT ON

CREATE TABLE #TABLE_REPORTS (

[user_id] char(1)

, report_name varchar(10)

, descr varchar(50)

)

INSERT INTO #TABLE_REPORTS

VALUES ('A', 'report_a', 'first month report')

INSERT INTO #TABLE_REPORTS

VALUES...

This depends on whether you want to shell out for another SQL Server License or not. Installing Reporting Services on your existing SQL Server will avoid that. Installing it on...

A Grand Total is generated for the first "Row Group".

Eg: If you have subtotals for three row groups (Country, State, City) you will get a subtotal of cities for each...

Where is the ReportServer installed? Is it on the same machine that you are developing reports on? If not, youll need to change the project properties to point to the...