I just need to understand one thing. If you have a DML statement that updates multiple records (whether Insert, Update, or Delete), does the trigger fire multiple times (once...

One thing about SSIS is that you can pretty much NEVER see the variables being updated. You just have to assume everything went well. If you really want...

The easiest way is to create an XML Task in SSIS which reads in an Xml File that contains all the Servers and Credentials that you need to connect to...

Yes, setup a DataFlow task which imports these files. Add a Connection to the Connection Managers for the File (you might need to setup a different Connection manager if...

Start with an "Xml Task" (maybe nested within a ForEach File Enumerator if you have many files to process). Here's how my Xml Task is setup:

Operation Type: XPath

Source Type:...

Robert, you can probably also set the variables by using a Named Parameter (this probably requires an ADO.NET Connection). You query would need to include that parameter: "Select...

In my experience with running Queries in .NET apps vs. Query Analyzer is that most don't actually call the Procedures or Ad-hac queries in the same way. For example,...

I've used this before and it works nicely. There's really little performance impact because you're not really going to need to parse the audit data all the time.

You might...

Sorry, I should have been more specific. Do the logs still contain Re-indexing transactions if the Recovery Mode is set to Bulk Logged?

Does anyone have an idea if Log-shipping will propogate the ReIndexing on the destination server? For example, if we're reindexing before shipping the log, will those changes be seen...

Never mind, I figured it out! This Xml crap is definitely a LOT harder to figure out than OPENXML. At least with OPENXML you could guess better what...

This really doesn't explain anything about selecting values from Elements in the Xml. You should have explained both scenarios: 1.) having values as Attributes (which you did) and 2.)...

Hmm, I'm not sure I really want to do that. I have managed to consolidate the data down to 42,000+ records, however, I can't imagine inserting all that into another...

I'm quite aware of that. The function I wrote contains a Parameter "@Accuracy" which can be set 1 - 3 (1 being the most accurate). I posted the...

Thanks for the replies, I guess it had to be done the long way. BTW, this was for a function, the function was enhanced using bits and pieces from...