Per BOL

Parameters of all SQL Trace stored procedures (sp_trace_xx) are strictly typed. If these parameters are not called with the correct input parameter data types, as specified in the argument...

Working from the inner most () out it does...

substring(pos, pos) picks a character from a string

ascII() get's the ASCII code for the character it chose from the string...

the IF() compares...

here's a link to an article that discusses it's use and how to create one etc..

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Basically it's a table that you can add to your database to help with calculating dates.

You can add whatever information you might need.  You can pretty easily genereate one and...

Can you give a bit more detail on what is supposed to happen when you execute Project.exe?  Are you expecting a return back, or is this just taking an action...

have a look at sp_grantdbaccess in Book online.  I think it will be helpful.

Hacking the System stored procedure may put you into an unsupportable instance of SQL server.  so you may want to rethink that...

You could create a stored procedure that gather the...

You might try using a calendar table to track workdays or you could just use

datediff(dw,date,date)  The dw datepart is weekdays.  This won't account for holidays however, hence the suggestion...

I did, it's at the end of my first post, but here it is again...

localdll Method

PUBLIC Function MyMethod(Errtext, Param1, Param2, myRS, User)

 Dim StrSQL AS String

 StrSQL = "SELECT value, ID FROM...

It's not the word doc that I'm having issues with.  I think it's the other dll I'm having issues with.  the line of code that errors and returns my error...

The file is written properly, it's saved renamed and reopened correctly.  The problem comes after it's already been reopened and I'm calling my other Dll's to pull in data to...

Yeah, I've been through all of the files involved, it's word automation that I'm doing, but the manipulation of the word documents are fine.  It's actually one of the calls...

Absolutely!

yes the odbc datasource would be a DSN either on your server or on the client machines depending on how you are setting up your application.

u could have a look...

"the easiest & [most] effective way" means a lot of different things to a lot of different DBA's in different environments...

Questions to ask yourself...

What am I backing up,

How Often,

what is...