Problem: You won't give us what we ask for so we can't provide you with the answer you are looking for.

You only give us half answers to our questions, what...

May just be me, but I'd keep the filter in the stored procedure, unless the users also have access directly to view and not just using the stored procedure.

Even disabled jobs can be run. You can do so manually by right clicking on the job and selecting start job, or using msdb.dbo.sp_start_job stored procedure.

paul.starr (11/13/2008)

---

CREATE TABLE [dbo].[CustomerAddresses](

[CustomerID] [dbo].[C_ID] (nvarchar(30))NOT NULL,

[AddressTypeID] [dbo].[C_ID] (nvarchar(30))NOT NULL,

[CustomerAddressID] [dbo].[C_ID] (nvarchar(30))NOT NULL

insert into dbo.CustomerAddresses

(CustomerID, AddressTypeID, CustomerAddressID)

values('48313', '1', '48313-1')

('48313', '4', '48313-4')

...

You're going to hate this, but...

Please provide us with the DDL for the table (the CREATE TABLE statement), sample data for the table (as INSERT INTO statements), what you have...

:unsure: ??

I'd contact the vendor and request their assistance.

Personally, a separate job for the system databases.

Looks like this may be the way to go. I amy have to look at the output clause in a little more depth for other uses in my environment...

Slightly...

I'd look at using the OUTPUT clause with the insert. You may be able to get the identity value assigned from the INSERTED values.

Haven't tried it, but it is...

No. It doesn't. You have to give us something that doesn't require more than cut and paste to use. ...

In SSMS, you can right click on the database and in the pop-up menu select Generate Scripts. Using the wizard, you can select the databae, in the options page...

MERGE is new to SQL Server 2008, doesn't exist in SQL Server 2005 and earlier versions of SQL Server.

Just keeping you honest! :w00t:

I still haven't even hit 3,000 forum posts, but I'm getting close!