Agent Jobs are stored in msdb - you could try restoring that database to the new system.

Your best option would be to use a tool that is built specifically for this. Melissa data (http://www.melissadata.com) is one of the better recognized providers.

They have the ability to...

Since you are on SQL Server 2005 - you might want to look into using synonyms instead of using the four-part naming convention in your code. I would recommend...

Yeah - I...

antonio.collins (12/3/2008)

---

Jeffrey Williams (12/3/2008)

---

Is this what you are looking for?

;With history (regid, status, history_date, rn)

As (Select reg_id

,status

...

Your data file is restricted - what is the max size allowed? What is the auto-growth increment? How large is the transaction log (goes to determine how much...

Is this what you are looking for?

;With history (regid, status, history_date, rn)

As (Select reg_id

,status

...

Tempdb will grow as large as is needed to support the queries being run on your system. Once the database has grown - it will not shrink until you...

Bummer - my new slingshot is back-ordered. Should be available and delivered in the next 6 to 8 weeks, shipping & handling charges extra (of course) :hehe:

If the only thing the process is doing is inserting data into table variables and/or temporary tables, and then selecting from those tables - then there is no reason to...

Review the following:

Select dateadd(month, datediff(month, 0, current_timestamp), 0)

,dateadd(month, datediff(month, -1, current_timestamp), -1)

,dateadd(month, datediff(month, -1, current_timestamp) -...

Naw - have plenty of pork chops, I just need something to sling them with :w00t:

One thing you can try is adding a clustered index to those tables. Once the clustered index has been built, you could then remove it if you really need...

I am still curious as to why you need to know if a parameter was passed in or not. It really shouldn't matter.

No way that I am aware of. Why would you need to know that information anyways? If you are going to do something different based upon whether or...