Interesting. Don't see this procedure anywhere. A hidden MS thing?

Steve Jones

steve@dkranch.net

you are welcome and it was interesting. Hopefully others will learn as well.

Steve Jones

steve@dkranch.net

haven't seen anything and don't see a pwd column in the table.

I'll keep looking.

Steve Jones

steve@dkranch.net

Nah, the search guy probably didn't update his search while we updated the site. Thanks for the catch and we'll get on it.

Steve Jones

steve@dkranch.net

Haven't tried it, but do you really need word? RTF, HTML, numerous other "template" formats would be easier to manipulate.

Steve Jones

steve@dkranch.net

When it runs the pacakge, does the VB program load and run the package or call sp_start_job?

Steve Jones

steve@dkranch.net

use a role!!!!!! don't grant rights to users!!!

http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp

Steve Jones

steve@dkranch.net

Don't think you should have an issue. I have pacakges that run multiple copies of themselves and I code to prevent it, but they both work.

Steve Jones

steve@dkranch.net

save always works. I use this every day in development. It defaults to "untitledxx", but there is the ability to change that. Have you tried "save as"?

Steve Jones

steve@dkranch.net

I thought my book was pretty good, but I know the complaints are mainly on the first section of the exam. We reverified our questions were similar to exam questions...

Well as the co-author of he Sybex book on 70-229, I have a resource out there in print.Seriously, I took 229 and 29 and thought 229 was...

Could it be the underlying tables based on the data being inserted? Other than that, it seems strange? Have you run profiler to see if there is something you are...

The service manage provides a GUI for the net start and net stop command lines. If you have windows rights to do this, you can execute this. It has nothing...

The collation is the code page and sort order used for the table. This affects storage and display. In older versions of sql, there was a single code page and...

I noticed something similar investigating the use of a stored procedure with two queries and switching. The sproc still appeared to alter its plan without a recompile. Not sure, but...