strSql11=" insert into TempItem (intId,intWebId, intDataType, intNavid ) values (coalesce(" & intId & ",0), coalesce(" & intWebId & ",0), coalesce(" & intDataType & ",0), coalesce(" & intNavId & ",0)...

this should do it

SELECT j.NAME,l.name FROM msdb..sysjobs J

INNER JOIN master..syslogins l ON j.owner_sid = l.sid

well, you have several options. You could archive old data off to a different database if that is an option for you. You can separate the data files onto separate...

no, we are still on  2005 sp1. I'll try and restart the agent and see if that helps - thanks

this is what we use to roll through all our databases and tables to reindex

declare @db varchar(50)

declare getdbs cursor for select name

from master..sysdatabases

where name not in ('master','msdb','model','tempdb','pubs','Northwind')

for read only

open...

that is exactly what I'm looking for. I was wondering if you could get the physical name from SQL. Great solution. Thanks!

that is a great suggestion. Thanks

I also thought about setting a cluster resource as a generic script and send an email when the resource comes online, but I'm not sure...

we have 32 bit running on 64 bit windows. We are having trouble with SSIS, but the database engine works great.

your right, I was thinking function in a function, sorry about the bad info

yes

A lot of people use profiler for this. capture RPC completed for sprocs or t-sql statement completed for individual statements. This will give you an execution time. you can even...

in the execute sql task, use sp_Bob @Fname = ?

may need to name the parameter if that isn't your only global variable.

I think the syntax would be sp_Bob @FName...

it is possible to do. some things to consider - data and log file locations will need to be the same, or else you will have use command line to...

Did you uninstall the 32 bit version first?

--grab the return code from start_job like this

declare @return_code int

EXEC @return_code = msdb.dbo.sp_start_job @job_name='Audit'

if @return_code = 0 --SUCCESS

IF @return_code = 1 --FAILURE

--RAISE error here, see RAISERROR in BOL for more...