try this:

USE master



DECLARE @dbname CHAR(20), @name VARCHAR(12), @sql NVARCHAR(4000)



DECLARE dbs CURSOR FOR

SELECT name FROM sysdatabases



OPEN dbs

FETCH NEXT FROM dbs INTO @dbname

WHILE @@FETCH_STATUS = 0 BEGIN



SELECT @name...

Just wanted to point a couple things out that you may want to look at before anything else regarding this procedure:

1) There is no error handling anywhere in the...

This may be a silly question, but if someone with an NT username matching USERB is attempting to access SQL Server through QA using NT Authentication, wouldn't you get the...

Please post the stored procedure in question to get a response. Include the table schema in question.

quote:

---

update dbo.zMaster

set @RegNumber = RegistrationKey, RegistrationKey = RegistrationKey + 1

---

Antares,

Way cool! You...

quote:

---

There is no enforcement mechanism like you have in OO languages.

---

There are no mechanisms in...

What about:

DECLARE @ContractID INT



INSERT INTO manufacturerContract

VALUES 

(

   @manufacturer_id, @per_minute_percent, @rental_percent, @when_dt, @emp_claimed_id

)



SET @ContractID = @@IDENTITY



INSERT INTO manufacturerContractItem 

VALUES (

    @ContractID, rest...

why in the same statement? why not 2 insert statements?

quote:

---

1. ...sent where you got the syntax error...

---

already addressed. please read above...