I actually disagree

The reason I don't like square brackets, is that they was invented so that illegal names would 'become legal'.

What the brackets...

Is the real question: 'How can I make a copy of these two tables'..?

..or is there something else?

/Kenneth

Could you post the trigger so we can have a look at it?

Pretty hard to guess what's wrong with it, other than it's probably 'bad' in one way or another......

It does that when it can't find the object (tablename supplied as a parameter)

This happens if the proc isn't marked as a systemobject and you're standing in another db than...

Try this:

Change "EXEC vbaicms_dev.dbo.SP_GENERATE_INSERTS auth"

to "EXEC dbo.SP_GENERATE_INSERTS auth"

.. and instead add the dbname with the -d parameter

(-d vbaicms_dev)

...and/or check if the proc SP_GENERATE_INSERTS is marked as a systemobject.

If...

Best practice #1:

Always use objectnames that *don't* have to use square brackets in order to not crash your code []

/Kenneth

...or.... don't use illegal names with characters that's not allowed...?

/Kenneth

Well, imagine you stood in a door, letting people and families into two rooms.

Only one in each family holds a ticket.

The ticketholders goes into one room, all other familymembers goes...

This really isn't a data- or SQL-problem at all. This is pure display 'nonsense'.

As such, it belongs on the recieving end to format it, not on the querying side.

/Kenneth

This is going to be based on a lot of assumptions, but I'm using your example as matrix.

It seems to work, though it's 'old style', haven't messed with CTE's that...

The dll isn't actually there?

Some other dll that the mentioned dll is using is missing?

There is a permission issue on the dll? (or some referenced dll)

...any other reason why the load...

I do that sometimes, sometimes not. Traditionally, for all except sometimes tempdb, the issue is kinda moot from a performance standpoint, since the activity in master, msdb and model is...

I usually start out with four arrays...

c: - system/os and binaries

d: - datafiles

e: - translogfiles

f: - misc files, backups, logs etc.. (the 'junk' array)

In some cases you want to expand...

Still, in which order those 10 percent rows are finally presented to the client are not guranteed to be the same.

/Kenneth

I usually use the -C parameter when I need to convert chars between ANSI -> OEM or OEM -> ANSI in any of the directions file -> table or table...