I give you credit for trying to get to the bottom of it, but at some point you have to call it a black box and be done with it!...

The odbc dll is a dependency of sql-dmo. I think if you use the desktop installation you should get the files you need. Try this link, maybe it will help:

You're referred to the textbox you drag/drop into the designer then add comments to it? Just tried one like that, saved as dts, then re-opened without losing anything.

Soon for a...

Found a post that might help, looks like it might be a bug.

http://groups.google.com/groups?q=sql+xp_sendmail+watson&hl=en&safe=off&rnum=1&selm=ujGuiY0%23AHA.1420%40tkmsftngp07

Let us know if that helps.

Andy

Basically you need to do an update statement in the trigger that sets your date field = getdate() based on the rows that were modified, something like this:

update a set...

You just need to add your jobs to each server? How about using the master server functionality that lets you administer all jobs from one server?

Andy

Never ran SQL2K on NT, but I can say that administration is reduced somewhat by running on Win2K. We're definitely happy that we migrated.

Andy

I've seen that 40k figure documented a couple times, never thought to figure out where it came from. Not sure where to look just yet.

Could you give us some background...

Dont remember it being done.

Andy

You need to declare the parameter as output, both in the proc and in the code where you call it. Unless the param is declared as output, the 2nd sp...

This is how replication is supposed to work! When you set up a transactional subscriber, it gets a set of stored procedures created that the dist agent uses to apply...

Interesting. Worth doing even! So let's see what other methods we can think of to arrive at the same place.

One would be create a view on each table that belongs...

If its that urgent you may just want to restore from backup. What version of SQL are you running. Any messages in the event and/or error log? This is the...

Hi Sica,

Sorry for not replying to you sooner - things get busy on here sometimes! I know with Excel 97 there was a "feature" where if you tried to export...

I dont think being a domain member is a requirement, it just makes authenticating easier. If you're not a domain member you'll have to use either a SQL login and/or...