Im not sure what you're asking - you're having a problem with Notes?

Andy

Unless your new solution uses the same proc names with a new implementation, why bother? You never know when some other app may use them (or at least look for...

Should be able to bcp the contents of sysxlogins over - at least you can with 7.0 & 2000!

Andy

You tried it using sp_attach_single_file_db also?

Definitely. I use usp_ in general, usp_dba_ for my stuff that I prefer no else use/touch. Other ideas on this?

Andy

I've got a short article posted that discusses UDL's:

http://www.sqlservercentral.com/columnists/awarren/dsnless_1.asp

Andy

Unless Steve has a better idea, I'd reboot first, see if that helps. If that fails, try uninstall/reinstall the sp. Have you looked in the error log?

Andy

Best way is to just use sp_start_job to run your package. Do you really have a requirement to do the export real time?

Andy

Remove the log file, let SQL create a new one - will happen automatically if you use EM in SQL2K, use sp_attach_single_db in SQL7.

Andy

The first thing I see is that you're updating ALL the records, you need to join/reference the inserted table to qualify the update. Something like this:

update table t set t.a=(b+c+d+e)...

Pete, David, Palamon - if you'll email me your address, we'll ship each of you a poster - our thanks for participating here:-)

Future readers - we'll be giving away more...

I rarely use filegroups - in my view they are only useful when you get to the point that you're can't complete a full backup in the time allowed. But...

Books Online.

Why do you want to remove them? (I know thats not an answer!)

Andy

If you've got all those constraints (a good thing) do you want to bypass them when you load? If you're sure the data is good, go for it. DTS is...