I can't test this but off the top of my head you could try something like this:

begin transaction tran1

build an insert string

begin transaction tran2

create your table

exec insert string

commit tran2

send email

commit...

Here is the only difference I have found to tell for sure. On 64-bit sql instances this returns 2 rows

name

affinity64 mask

affinity64 I/O mask

SELECT [name] FROM sys.configurations

WHERE NAME LIKE '%64%'

on...

select @@version works for the 64-bit sql edition but i am not sure how to get the OS.

output from select @@version on 64-bit machine.

Microsoft SQL Server 2005 - 9.00.4035.00 (X64)...

When you open the maint plan in SSMS there is a button in the toolbar "Reporting and logging". I think that is what you are looking for.

Does this work?

SELECT r.oid,r.sid,r.rid from #b r

WHERE NOT EXISTS (SELECT 1 FROM a WHERE a.oid = r.oid AND a.sid = r.sid AND a.rid = r.rid)

I am with David on this one. Use a batch file in dos with sqlcmd to execute your sql or use xp_cmdshell in sql to execute your dos commands.

Try something like this to get out of the dynamic SQL

SELECT TOP 100 PERCENT T.*

FROM ( SELECT strEmpID, MIN(TD) as Times, DepCode as [Shift]

FROM EDS_TD WHERE DATEPART(dd,TD)

IN...

If the first connection is sucessful and you are using the .net platform to connect then the connection string will automatically pick up the mirror instance. Here is the...

Try seaching for a script with the sp_MSforEachTable. It is an undocumented stored proc that will loop through all the tables in the database. If you can't find...

check to make sure all of your columns are separated by commas.

DuplicateCheck and BatchNum don't have a comma between them.

Is something like this what you are looking for? I just used a temp table but check out the update statement. I think it is close to what...