Crosspatch is right as I see no index, also the other problem with having to do the left is the size will vary based on the other tables value. I...

When the job was create it should have created a DTSRUN encrypted version that it executes, open the job step and copy it out, then run command line prompt to...

I haven't had a chance yet to test it, but it is an interesting concept for moving DTS packages that I will have to play with it. Good job.

"Don't roll...

Sorry don't know anything about instcat.sql but don't think this is upgrading. As for what are your options. If you are programming for 6.5 you are better off sticking with...

Sorry don't know anything about instcat.sql but don't think this is upgrading. As for what are your options. If you are programming for 6.5 you are better off sticking with...

Ahh, crude. No you apparently cannot search titles of forum topics. Better post it this way then http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3109&FORUM_ID=23&CAT_ID=2&Topic_Title=Get+Children%3F&Forum_Title=General.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

Unless agent is running under system account which if it is the ODBC DSN then make sure the DSN is a system DSN and not USER or File.

"Don't roll your...

It will use all resources that it can and instances will negotiate to get what they can from each other a lot of the time. As far as overhead you...

Open the file and copy out a handfull of lines to another file the try the smaller file. It may be the linefeeds but there is so much I don't...

1) Is the place where tha package is built the same as the server it is saved to?

2) If not what version is the client and the server?

3) Are there...

Sorry it has been a while since we moved from 6.5 to 7, some of our databases were upgrade thru to 7 from 6.5 when installed 7 provides a utility...

Dooh, I knew those, just didn't have my cheat sheet in front of me. As for -L that is optional an really is only needed when you want to stop...

Quickest way to get is open enterprise manager and drill to your db and the tables in question. Right click on each table an choose copy, then paste into notepad...

Can you post the DDL of the tables so I can understand the structure. Also cursors can sometimes actually perform better than straight code but it is hard to tell...

Apparently to bcp it does matter as it will not work for me either on a db with a space in the name. However here is a work around.

Set the...