jcrawf02 (12/9/2009)

---

I have to say, jokes aside, I'm impressed with the group's psychic abilities, to be able to help someone with so little to work with. I think I've...

Check BOL for the syntax of the EXECUTE statement. I think you'll find that you need the OUTPUT statement on the parameters that are output parameters when calling the...

Is the following order of records guarantteed, or could you get a type 1 with no following type 0, or could you get 2 consecutive type 1's or 0's?

100, 2009-11-01...

If I may, what is this trigger doing?

If Jeff suggested that you do this, I suggest you figure out how to write the query using a while loop. Give it a shot. If you have...

How the .... did this person get a job in IT?????

The force in this one is not only weak, I think it is nonexistant.

Krasavita (12/9/2009)

---

This is what I get:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition...

My guess, from the...

Bru Medishetty (12/9/2009)

---

Right click on SQL Instance in SSMS, select properties, the initial properties windows lists the Server...

Ask your system admin.

You can also run this in Query Analyser: select @ @ version (no spaces after the @ signs). If you see x64 in the returned string...

Actually, you want a LEFT OUTER JOIN.

create table dbo.TblA (

Model char(1)

);

create table dbo.TblB (

Model char(1)

);

insert into dbo.TblA

select 'a' union all

select 'b' union...

At this point in the trigger you no...

doran_doran (12/9/2009)

---

Lynn,

Actually, at this stage I am just trying to create the trigger so I will not be received access denied.

However, I already check the sp in new windows...

Anyone have a polite way of telling someone to learn how to debug their own code?

I'm trying to help, but any time I try to write something about doing their...

The second error message is probably caused by this part: EXEC msdb.dbo.sp_send_dbmail . You don't have access to the inserted table at the point you are trying to create...