I do not trust sysindexes row value. In SQL 7 this value may not be right at any given time. There is a KB Article but I cannot find it...

If I find any other way I will pass along.

Personally, go with 2.7. 2.6 works fine for me and has been more dependable than 2.5 was as Scorpion sates he ran into. However, 2.7 is starting to remove least...

If still red afterwards look at the job history by right clicking that job in EM and choosing job history, then check show all steps and it should tell you...

This really isn't an issue as if you read the documentation MS created this is the reason they tell you to be carefull with your ownership chains. This includes the...

But my concern for the setup is the single array controller. If it does not support multiple channels then you get the IO from one drive array set at a...

Had to do this in 7 which did not have the FTP option. What we did was script an FTP command line task and the command item in Job to...

Not within SQL itself as there is no trigger or other mechanism for SELECT. You can however setup Profiler to monitor SELECTs in all databases and write to a table...

No not to an existing publication. Must drop and recreate or create a new seperate publication.

Other than that I don't see anything. Just one note make sure you are concatinating you value in I sse you have

"EXEC db.dbo.proc_name + @parameter")

should be

''EXEC db.dbo.proc_name '...

It seems like something had to have changed and with the DLL you are getting down to comparing them for differences. Also, by posting the DDL of the tables and...

I spend so much time arguing poitn and counterpoint to some of my fellow developers that I start making their mistakes in developement. But as I tell them, you don't...

Find the guy and beat the crap out of him for not leaving documentation.

Unfortunately, the password is encrypted with the package data and unless you try...

Yes even with SQL 7 as long as you have the script debugger you can do it.

Quote from http://www.pinnaclepublishing.com/SQ/SQmag.nsf/47636d6fac28ed5e8525688900418db5/eec9d37707cec305852568d90047a6b1!OpenDocument

quote:

---

There will, of course,...

Unless this is in the Beta area for subscribers I have not seen any mention on TechNet.