Thank you George. I will definitely read the article.

The size of this particular database is 126 GB, with the largest table being a little under 69 GB.

The sp description...

Hi everyone. I am having the same issue that Marker is having. I have recently been tasked with taking over DBA responsibilities in my department. I'm excited...

Hi. I found an old DTS package that I was going to use. Essentially, I set the DTS package up in this way:

I have a connection to the...

Hi. I wasn't able to get the DTS package to work, but I was able to use openquery to pass data. Ultimately, we ended up not using MySQL...

Steve,

I have mixed views on the subject. In one sense, I think a company is almost obligated to use its own software if it makes sense for the company....

Lynn,

Reading my question, I realize I was asking a question that belonged with my other forum question regarding sending notifications.  I was trying to figure out a way to know...

What could I use to find out when the line inserts are complete?  Would I loop through the detail table and when the orderid changes, the loop ends?

Thank you, Bledu.  I actually did add that column earlier today...based on your earlier suggestion I think.  The developer I am working with does not want to populate that column...

Bledu,

Thank you, thank you, thank you.  It worked.  Really...I cannot thank you enough.  I have been wracking my brain for almost 2 days.  My final code is:

declare @body1 varchar (200)

declare...

Bledu,

I can run the select and get the expected result.  Let me explain a little more.  I began by trying to send a notification for just the max order id. ...

Can anyone help with this?  I would appreciate any suggestions you may have.  I am at a loss as far as how to get this to work. 

Maybe I should set...

Ah, now I understand why the function I created in our test environment set the line numbers to 1 for each line   I...

Thank you, Paul.  I never thought of creating a function.  I think I'll try it out as a test, even though we aren't implementing it in this database.

One question regarding...

Hi.  I'm pasting the ddl for the tables that are required within this script.  One thing I should add, which your suggestion reminded me of, is the application is actually...

One more thing...I posted this in the wrong area.  I'm working with SS2K, not SS2K5.  From a syntax perspective, this won't matter, but it probably will if we are talking...