Nice article Ken. Makes me think I need to be doing more. I particularly like the fact that you included all the links in the article. This...

I do a little ASP.NET, but would not consider myself an expert.

If you have questions you could do as Grant suggested, try posting here in the Programming\General forum or the...

I meant more like the last post on this thread: http://www.sqlservercentral.com/Forums/Topic608342-145-1.aspx

I see what you mean. I have usually dealt with single row inserts from a UI. How have you dealt with this issue prior to 2005? That...

rbarryyoung (11/26/2008)

---

Jack Corbett (11/26/2008)

---

Yup, that is correct. Of course shouldn't you already have a project with the scripts...

Yeah it does seem like there are a many questions that are unrelated to SQL and/or are incomplete, but it also seems I am getting more feedback lately on the...

I would recommend against doing this in a trigger anyway. The trigger takes place within the original transaction so if the trigger fails your entire transaction will roll back.

Have...

If the relationships are already created then changing schemas should not remove them.

Grant Fritchey (11/26/2008)

---

Matt's nailed it. If you went for the identity value on the table, you could get someone else's insert value. OUTPUT pretty much guarantees what you're getting. Still,...

When you put it in the stored procedure that is when you can have an issue with parameter sniffing. Which is basically means the optimizer "guesses" the parameters and...

Yup, that is correct. Of course shouldn't you already have a project with the scripts in Source Control?:D

If all that is already done then I believe it...

Nice script Barry. Is there one that will work on 2000?

SQL Server 2000 does not enforce any password policies like expiration or max invalid logins. If you want this you need to upgrade to 2005/2008.

From BOL:

Syntax

ALTER SCHEMA schema_name TRANSFER object_name

Arguments

schema_name

Is the name of a schema in the current database, into which the object will be moved. Cannot by SYS or INFORMATION_SCHEMA.

object_name...