Don't buy visual source safe, it blows chunks, badly. Really.

If you want a simple audit trail, write a CLR DDL trigger which scripts out the changed object and saves it...

http://msdn.microsoft.com/en-us/library/cc280436.aspx

SSSolice (9/22/2009)

---

No. Thanks. There is a Where clause. The syntax is not the question. I can fix the join. A while back I...

99% likely because the other machine does not have a file/folder D:\... whatever it was ...

There is a way to do it automatically - just enumerate through the names of the columns in your source, adding each one as an explicit bulk copy mapping... I...

Erm... there is another way - check out ROW_NUMBER, OVER clauses and the PARTITION BY statement.

You have two virtual tables available in triggers, deleted and inserted. inserted is valid for INSERT and UPDATE triggers, and deleted is valid for UPDATE and DELETE triggers.

deleted holds the...

0x prefixes a hexadecimal number.

Use windows calculator - type in a number, press F5 to turn it into hex. Type in a hex number, press F6 to turn it into...

rjv_rnjn (9/22/2009)

---

Errr - yeah - that's why I...

To be honest, most people call it 'old style join'... lame huh?

danielmanke (9/14/2009)

---

Unfortunately, the application is an off the shelf

ERP and I have no control over the development and function of this code. At one time it was a t-sql code...

eko - you may also want to consider, if you're at an appropriate stage in the project, whether you want to use the SOAP endpoint because the feature is deprecated...

You're seeing two SPID 60's because there are two sub-processed with different ECIDs - i.e. more than one thread is running the query on behalf of that SPID.

That's assuming there is no where clause after the...

And thank god for that!