You can use the Scheduled Tasks feature of Win - look under Accessories, System Tools, Scheduled Tasks. Zipping is not a bad idea, but you have to consider both the...

Now thats an interesting question! If you can't find a function in master, it's in a dll somewhere and inaccessible. Found this snippet, which is useful but not quite close...

Not familiar with 6.5 tools (hoping to keep it that way!). If you have Interdev, I think the editor allows you to make changes visually, does the scripting behind the...

Nope. Do it as a two step process, back up to local disk, then use a batch file to move to other matchine.

Andy

Hello Peter,

Couple suggestions that may help. One is to take a look at user defined functions which are available in SQL2K - I think you'll find they provide code reuse...

Couple options. One is that you can return multiple recordsets - each select will return one - in ADO take a look at the nextrecordset method. Another would be to...

Can you ping the machine? Sounds like a connectivity issue. Dbl check your password also.

Andy

I know there is a timeout for it, don't recall seeing one for close. Why do you care if the connection remains?

Andy

Exec server.master.dbo.sp_help, you have to have RPC out enabled for the linked server I think.

Andy

Sure. Or just delete (kill) the file if it exists before you export.

Andy

Looks like you didnt provide an SA password - it is really blank?

Andy

I don't think you need a cursor for this - an outer join should work well. Something like this:

insert into table a (column names here)

select (all your column names from...

No problem at all! Hated to post the answer, was afraid I was misreading MY results!

Andy

Nope. If you don't have a column that is really worth using it on, at least use it on your primarykey.

Andy

Cut off in QA? You can change the max size of a column in options.

Andy