Sorry Truncating tables does not allow for direct recovery. The thing I would do is create permament temp tables, move your data to those, truncate the main tables, run your...

It could have been a number of things including going nuts looking for a support file that is missing. Check the Event Viewer and see if anything in Services or...

Did you reboot after you removed the registry keys, and if so which registry keys did you remove?

And make sure you delete all the items in the temp folder to...

Or if you use the 'at' cmd line scheduler. If you do not have the Task Scheduler in yuor version of NT/2000/XP (NT 4 was the only one lacking from...

I havwe never had trouble with this in ASP on VARCHAR or CHAR datatype of 8000 length(never needed to do text types).

Check the source code of the page to see...

After getting home I tried looking for again and found something this time (I hate filtering sites on firewalls).

http://www.umachandar.com/technical/SQL70Scripts/Main15.htm

quote:

---

-- General Note:

-- Use...

I do believ the point is the fact that if you create a user defined sp with sp_ in master and execute it from any DB it works right.

But...

I believe so. I will check SQL 2000 and SP1 to see if this has always existed. Will also throw into testing with SP3 with a friend just to see...

I check SQL 7 SP4 and did not remove. I will see if I can find additional information.

This seems to depend on the JDBC driver version you are running as some folks do not run across. Try adding

SelectMethod=cursor

to your connection string like this

pmf.setConnectionURL("jdbc:microsoft:sqlserver://xxx;databasename=yyy;SelectMethod=cursor");

and see what happens....

When you di the full restore you let the database recover. Once the database has recovered no additional Differential or Transaction log backups can be restored. You will have to...

Hey wireless, I got your email, I don't think the problem is in the queries directly, I believe your missing a key to the join. You must have multiple records...

Sorry, no documentation on this, I checked everywhere I know of and even so old 6.5 reference material. I suspect it may be part of the internal threading process based...

Then you really have two choices

1) Use Export wizard to export the SPs to the remote servers.

2) Use the generate SQL script option to generate a single script file with...

SOrry, my mistake, I misread and did not pick up the "setup" part of the post.