Or if you want to get it with all the parameters schedule it and the disable the job. This may be your better since xp_cmdshell must have the rights to...

Great to hear, and I was only stabbing based on issues we have seen with Crystal Reports pulling data over the ODBC as compared to the OLE driver.

"Don't roll your...

If nothing else you could rewrite you database forms to connect via ADO instead of linked tables (this is one step below writing a full vb app). Then you can...

This may still apply with 7 and 2000 but not sure. Check out http://support.microsoft.com/default.aspx?scid=kb;EN-US;q90758

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

I have done this on numerous occassions and will be glad to help. Please post the DDL of the table as this will help me better understand your needs.

"Don't roll...

What terryute shows should work, but you will have to use dynamic sql to do.

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

Just make sure Data Access, RPC, RPC Out on the Server Options tab of the Linked Server properties are enabled. Works great for me.

"Don't roll your eyes at me. I...

Also the job generally has a retry number and retry interval by default they are 10 and 1 minute. This can be found in the job on the steps tab....

Then change it to something useless, this i what I did.

UID=EnterYourUserName

Now they even have a hint of what to do. Then you just copy the file dsn from machine to...

This table is stored in the publication and subscription databases. And it only exists if the is a merge publication, the sp however exists either way.

"Don't roll your eyes at...

You cannot resotre just the database without the log file. It gives the error not found. You can however restore the database and log and use sp_detach_db to remove it...

Theses errors are all related to the incorrect placement of the go as stated in the previous messages, so all should clear up as soon as you make the change...

Try the OLE driver.

cn.ConnectionString = "Provider=SQLOLEDB; Data Source=server_name_or_address; Initial Catalog=database_name; User ID=username; Password=password;"

I use it quite often and handle upwards of three recordsets in some pages for various reasons.

"Don't...

Not if defined as #tempTbl this is local only and only available in 1 procedure as once the procedure ends the table is cleanedup, must be ##tempTbl which makes them...

When you use the export wizard, choose copy objects and data and there is a option (uncheck default options to access options I believe) that does this.

"Don't roll your eyes...