Oops. Missed that this was SQLCMD

That's OK. You can use SQLCMD variables the same way, still using OUTPUT parameters. For more on SQL Command variables, this is BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/793495ca-cfc9-498d-8276-c44a5d09a92c.htm

Or online...

Use output parameters. They work a little like this:

--create a procedure

CREATE PROCEDURE dbo.MyProc

@ID int OUTPUT

AS

SELECT ID FROM schema.Table

GO

--now you can call the proc like this

DECLARE @LocalId int

EXEC dbo.MyProc @ID =...

I think you've hit the nail on the head here Tony. I don't agree with either of the wild fringe groups. I think that well designed apps take advantage of...

Permits? We don't need no stinking permits.

Seriously though, the main reason I keep coming back here, well, in addition to learning something every single day, is that the tone is...

Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First time in 10 years...

I'm sort of loving the long weekend. I'm busting butt on the stupid book and I'm chain-sawing & splitting wood to get ready for the winter.

Broke a chain for...

rbarryyoung (11/29/2008)

---

Probably himself. Seriously. It's easy...

rbarryyoung (11/28/2008)

---

it's not too bad, Grant. The presumption is that all tenants are using the same software and schema, just that every data row is tagged with a Tenant...

May as well chime in on this one.

First off, Phil, feel lucky. At least your developers are still at least using the words "data." We've had a rash of the...

Yikes! I'd say so. Upgrades to the data model must be entertaining.

GilaMonster (11/27/2008)

---

It could be worse. Like this one - developer background, now a senior DBA, depends on forum answers to do their job

Train wreck waiting to happen.

If you want some...

J (11/27/2008)

---

First off, WHY do you "need" (??) to create tables and set table ownership ?

Could you not just use a common table with an extra field like "OwnerID"to keep...

Jeffrey Williams (11/26/2008)

---

Or, you could try using SET FMTONLY OFF; in your stored procedure. One thing the TableAdapter is probably doing is running the stored procedure with format only...

It sounds like you're getting parameter sniffing. You need to force a recompile on the procedure. Take a look at plan guides and see if you can implement one with...

Another vote for that book. Great read and good information.

Just remember that getting the clustered index right should be task #1. All other indexing flows from there.