you can provide the location at install time:

- using the install GUI (advanced button)

- or using an installation INI file.

there is a template.ini file on your...

afaik : Yes you will have problems !

They can open in tran-scope, but they can only be closed after the tran-scope has completed.

Reason: MSDTC needs open connections to perform the...

well ... the "old" way ..

in stead of sending one mail to x recepients.... send x maild to one recepient at a time.

seems like a bug in your xpsmtp ...

Is...

columns_updates just says is a column is updated, it does not contain the value.

from bol

To test for updates or inserts to specific columns, follow the syntax with a bitwise operator...

- is this step run with another user than the rest of the job?

-since you're on sql2005 (forum) did you try it with dbmail ?

(avoid the overhead of mail-client)

If you put your db-files on a remote disk, you are network dependant !!! (availability/latency).

Sans are directly connected to your server and are prefered.

Sans are used like any local drive,...

like it says User Defined Function is supposed to perform some kind of

functionality (e.g. calculation, regex, ...) for you.

Most of the time based on parameters (row-level !).

Keep it...

- 8004005 is most of the time an authority issue.

- are you sending attachements ?

- post the jobstep / full job create script, maybe we can help out.

I would suggest to use the tool it is normaly managed with.

i.e. dcomcnfg

Especialy if you are not familiar with these settings !

Keep in mind these are also security settings !!!

You...

why would you even think of using dynamic sql for this ??????? :sick:

If you know it's only the predicates that differ, why not have a bunch of if statements...

first of all you'll need sql2000 enterprise edition !

This is the ref I always use : http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

- Did you take a look at log-shipping ?

- or work with full backup once a week and the other days restore the db and apply (the smaller)...

Can you find anything in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap

Take a look at the logfiles of your install processes (even if they seem cryptic).

And make sure you're connected to the...

Actualy , today I had contact with MS, and it turned out to be a flaw in SP_Helpuser (since SQL2000 RTM)

SP_helpuser calls sp_helpgroup wich truncates this to 25 chars.

If you...

Well, you know how it goes with defaults , someone may have tampered...