... or just:

select dbo.fnGetSQLBuild()

How are you kicking off the smtp mail? Via stored proc?

declare @jobname varchar(1000)
select @jobname = name from msdb.dbo.sysjobs where job_id = [JOBID]
print @jobname
exec sp_my_admin_email @jobfailed = @jobname

It'll work. Although unless your login connects you to the proper database, you'll have to specify the database name in the statement.

bcp "exec [dbname].[owner].sp_query @myparam='Hello'" queryout myfile.txt -c -T

In visio, from the menu, select File->New->Database->Database Model Diagram. Then select Database->Reverse Engineer.

Try it with bcp.exe, RTRIMming your fixed length CHAR columns, such as:

  bcp "select id, rtrim(name), email_address from test..contacts" queryout contacts.txt -c  -t; -T

Nice find Ed. It's even in BOL under sp_add_jobstep. How've I missed that?

Try this...

select 1 as Tag, 
       0 as Parent, 
       ID as [Configuration!1!ID], 
    ...

I'm not a big fan of dynamic SQL, but sometimes the situation requires it. A couple of possibilities:

To minimize code clutter, you could code the main select statement as...

On 2000, if your job step is a T-SQL step, the job_id appears in the master..sysprocesses.program_name column for the current @@spid. You'll have to parse it, and convert the...

Try taking the database offline, then dropping it.

alter database DBName set offline

SQL 2000 most definitely allows you backup/restore individual filegroups. You can even do individual filegroup restores from a full database backup. What I can't seem to make it...

I've experienced this before when I've included events that do not return data for the column being filtered. The solution is to remove those events. What events are...

Actually, the user already has the neccessary object permissions to run sp_addlogin, sp_adduser. These are granted to public by default. However, the stored procedures themselves enforce elevated privileges...

I think I found the same thing you did. From BOL:

"Do not set set working set size if you are allowing SQL Server to use memory dynamically. Before setting...

Isn't that what I did? Here's the same query with explicit select list, sample data & results:

declare @Payment table( hCtrlNum numeric(18, 0) not null,
     ...