oops; duplicate post after editing, so i trimmed the oldest. see below.

see your database trigger EventCapture?

do SELECT OBJECT_DEFINITION(EventCapture)

you'll see that that's the culprit; it's writing to the table in the database 'dbEvt.dbo.DTA_Events_Log'

instant fix is to disable the trigger:

DISABLE TRIGGER EventCapture ON...

One of the frequent posters here Elliot Whitlow posted a CLR project on CodePlex that does a lot of file manipulations, including a FileExists;

if adding CLR is an option in...

ok i'm HOPING this lazy fix is correct;

instead of going to find the columns that consist of the primary keys of a table constraint,

is it true that your tables are...

dndaughtery (10/4/2012)

---

I am attempting to use a Transfer SQL Server Objects Task to copy tables, udf, stored procs, and views from a src db on another server and copy them...

it sounds to me like there's a server wide or database trigger tracking DDL changes, but the auditing table hasn't been granted rights to teh users doing DDL, so it...

and a basic example of the trigger:

CREATE TRIGGER TR_UPDATE_EXAMPLE ON SOMETABLE

FOR UPDATE

AS

BEGIN

UPDATE SOMETABLE

SET LastModifedUserName = SUSER_NAME(),

LastModifedDate = GETDATE()

FROM INSERTED

WHERE SOMETABLE.PKID = INSERTED.PKID

END

I have this saved as a handy auditing snippet;

all these variables are available in 2008 and above, so if you have an audit table, just include some columns for the...

here's a couple of examples i made from another forum post.

this one was just a basic example, where something normally done by a sysadmin, can be delegated tro a...

As you are discovering,...

this site has the most comprehensive list of attributes you can query that i've ever tripped over:

http://www.rlmueller.net/UserAttributes.htm

specifically, his excel spreadsheet has a ton of stuff:

http://www.rlmueller.net/References/Schema.xls

i searched for "locked" and "enabled"...

ahh "bin packing" was the keyword; I've got a lot of saved scripts, could't remeber the label for it.

I wrote a script i wrote long ago, but my version...

definitely non sequential/gaps are involved;

i'm trying a mini tally table and n-1 transactions, but i keep thinking i...

looks like a simple grouping problem..is this homework?

SELECT

Col1,

MAX(Col2),

MAX(Col3),

MAX(Col4),

MAX(Col5),

MAX(Col6)

GROUP BY Col1

i'm thinking that you need a case statement plus a min, ot get a status/status indicator.

you cannot use alphabetical order of the statuses, because In Progress comes before Initial

maybe change...