Craig,

You wrote

>>> CREATE TABLE FooBar (FooBarID INT IDENTITY( 1, 1), <tabledef>) should work just as well. If it's a matter of needing to know the ID for multiple inserts, look...

Thanks for the answer Lowell!

Barkingdog (from one dog to another.....)

Thanks to everyone for some really fascinating answers.

Barkingdog

Paul,

The column is defined as NOT NULL and there are no indexes or constraints defined on the table.

Barkingdog

Jeff,

You wrote "Actually, you don't need TRY/CATCH for any of that. Take it out of the above query and see what happens." I tried that and found that, indeed, I...

Figured it out. Needed to import package under SSMS, Integration Services connection, not from BIDS directly.

grrrrrr!

That was helpful.

Would this interpretation of the original code be correct?

>>>

USE AdventureWorks;

GO

BEGIN TRANSACTION;

BEGIN TRY

...

COMMIT TRANSACTION;

END TRY

BEGIN CATCH

...

Here's another twist from http://www.sql-server-performance.com/tips/covering_indexes_p1.aspx

>>>

If you want to create a covering index, if possible, try to piggyback on already existing indexes that exist for the table. For example, say...

Adi,

You wrote

>>>

Most chances are that when you added the other column to the index, the index was a covering index. A covering index is an index that is composed...

Lowell,

That is a very interesting idea which I had not heard of before.

Thanks,

Barkingdog

Thanks to everyone for the good ideas. All of the posts offered different perspectives, just what I wanted.

Barkingdog

Good idea.

Thanks,

Barkingdog

>>> Once again - if your default system roles are not owned by the dbo principal

My default system roles are owned by dbo. My default schemas are not.

Barkingdog

Jeffrey,

You wrote

>>> I have not found a reason yet to create a schema that was not owned by dbo.

I may have misunderstood what you wrote but every "standard"...

You're right Steve!

Originally I followed this path for the fixed database roles. (I expected to see how Microsoft had setup the permisions). And there is no securable tab for...