I'm a developer. I think they would understand if you told them to just do it for readability. With a decent editor you don't have to type the column names...

You might try scripting all of your procs to a single file. Include DROPs when you are setting it up. Then put a BEGIN TRANSACTION at the top of the...

I think the actual script should have some hints in it. Why don't you post it?

Tom Garth

OLE DB uses SQLNCLI.1.

Tom

The following may or may not help, but it is excerpted from 2005 BOL.

To create or manage maintenance plans, you must be a member of the sysadmin fixed server role....

Without more details, I'll have to give you a generalized response. Never suspect a bug. Always remember "Garbage In - Garbage Out".

Your procedure is okay when YOU run it in...

Modify as required.

SELECT * FROM

OPENROWSET(

'Microsoft.Jet.OLEDB.4.0',

'C:\Program Files\Microsoft Office\Office12\1033\DBSAMPLE.mdb';'admin';,

--[Organization Chart Data]

[Office - Card Details]

)

Tom Garth

If you have purchased the 2005 Standard Edition, then uninstall the Express Edition's Management Studio, and install the Standard Edition's Management Studio.

Tom

I want to make sure there is no confusion about what I just said.

You can certainly create-alter-drop tables, views, indexes, procedures, and etc. with QA. You just can't get QA...

With QA, you can see the standard set of objects in the Object Explorer, and some actions are still possible because of the backwards compatibility for the old system views...

That is all pretty good stuff, and most, I didn't know.

I still use SQL Query Analyzer as my primary editing tool, and will continue to do so. I have even...

I don't know about the unqualified reference, but I do know that the 'deleted' temp table frequently contains rows that are NOT really being deleted, like during updates.

Why wouldn't you...

At the bottom of the Question / Answer page is a dropdown allowing us to specify how many questions to display on the page. Can we get a number lower...

Congrats Steve. A terrific discussion, especially the most recent part of it.

When it's all done, perhaps you could get people talking about time estimates. There's an issue I often have...

_{R L Reid}

I'll take us in a slightly different direction.

...and just when we had it all figured out, we were told that our reasoning had no depth.

Tom Garth