Ah. No, I don't think there's an option for leaving out the headers in that case.

That whole option is just a sort of crippled SSIS wizard. It builds...

It looks like someone tried to build a row-lock system to bypass what SQL Server does on its own.

Almost certainly, the slows this is causing are because of the "select...

Shouldn't have row headers in that case. What's the output method?

Is it possible that the insert statement is set up in such a way that it's trying to insert twice with the same ID/PK value in those cases?

(I'm guessing based...

Are you using a proc to write the output file, or an SSIS package, or something else?

Of course, there is always "Portability Light", but it only works on smaller databases.

You copy the database onto a flash drive, walk over to the other server ...

(I have a...

I like using ApexSQL Diff (similar to a RedGate product). Checks for differences between dev and test, and differences between test and production. Generates the scripts for me.

Then...

Jeff Moden (4/3/2008)

---

Portability? Have you ever tried to make 100% portable code and still have it actually do something more than return data to a GUI with simple SELECTs?...

That's not really enough information to judge.

By "map two databases to a new database", do you mean you're transfering tables and data from two databases into one database?

If so, what...

Having never heard of "explicit or implicit stored procedures" and not being able to conceive of how a stored procedure could really be "implicit", I did a Google search on...

Check out "openrowset" in Books Online. That might accomplish what you need.

In the From clause is better.

In Books Online, ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fb9696a6-1b2f-4d0e-baa4-e9c54211ea2b.htm

"...the join conditions in the FROM clause, which is the preferred method."

That article has a little more data on it, and why...

tthellebuyck (4/3/2008)

---

So to clear things up I have a param @mgrFlag that captures the permission from the app.

Orginailly I had this:

If not exists(select 1 from EmployeeAssocTable where EmployeeID = @EnteredForEmpID...

If you first convert it to a valid hex number (remove the colons), you should then be able to convert it to bigint using any standard hex to dec conversion.

Here's...

If you set up an "equivalances" table, with "Gardeners Botanicals" in a column called "Correct", and "Gardener' Bot'icals" in a column called "Variation", then you could have a person build...