Oh, sorry. Yeah, I did post the 2005 code. This is the 2005 forum after all. Sorry about that.

In addition to the suggestion above to use XML and XPath queries, you might look into the XML Bulk loader. It sounds like you've got a perfect place to use...

Subversion was recommended above. I've used VSS in the past. I'm currently using TFS, Team Foundation System, the new management tool from Microsoft.

Picking the code management tool is the...

I'd like to second this suggestion. You should treat the code in...

Actually, you could also get one of the third party log explorer tools and retrieve the older version of the procedure from the log IF you have your recovery set...

Not really.

You could restore a previous backup of the database to a different location and retrieve it that way.

Removing them and readding them will work. You could just run:

DISABLE TRIGGER ALL ON dbo.TableName

Just remember to run:

ENABLE TRIGGER ALL ON dbo.TableName

Otherwise, whatever the trigger does for you... it's not...

Depending on the data type & how you write the query, the MAX should work too. I've just found that the TOP... ORDER BY works better especially with a clustered...

I think that your SQL Server instance is running under the local service account and does not have access to the network. You either have to expose the network to...

Below my post is a button that reads "Add Topic"

Click that, fill in the blanks and more people will see the question.

I take it my answer wasn't helpful.

I don't know if I'd place a hard value on it like 1mb, but I suspect he meant that since table variables have no statistics, they're quick to build &...

Yeah, that list seems a bit light. I'd ball park it. If you're close, go for it. Unless it specifically states something like "Extensive expertise with MDX" or some other...

sg2000 (1/10/2008)

---

I have a View defined as:

SELECT dbo.TabA.Col1, dbo.TabB.Col2

FROM dbo.TabA LEFT OUTER JOIN

dbo.TabB ON dbo.TabB.ForgnKey = dbo.TabA.PrimKey

In this case, I got all of TabB col2 on the View...

You must have a trigger in place. Simply running that query as written should do what you want. Why you need to keep two copies of the same data I...

Oh, and if you want more responses, post your question as a new topic. You'll get a lot more people reading it that way and you'll probably get better responses.