Just another lovely Monday. Thanks.

It's close but I have to account for Holidays.

Last Working day is correct. I am not certain what the UDF would look like. Could you give me an example?

Thank you for your reply. After a little bit more research I came up with this which seems to work:

Dim con As

I have already installed the Sybase client on the SQL Server. that was how I was able to created DSN using Adaptive Server Anywhere 8.0 provider.

I went through the MS article and performed the following operations:

exec sp_addlinkedserver @server = 'HC90' ,

@srvproduct = 'Sybase',

@provider = 'MSDASQL',

@datasrc = 'HC90CentralProd'

GO

-- Adding linked server login:

sp_addlinkedsrvlogin @rmtsrvname = 'HC90',@useself='false...

Do you have an example of how that would work? I understand how the transformation from the text file to the work table would work but I am a bit...

Is the SQlAgent Mail tied to SQL Mail because if it is, I am able to use xp_sendmail without any issues.

Any help on this at all. I have the same question.

The proc is records records into a table from a textfile.

i wrote a quick and dirty VB6 program to make sure the data was being stored completely in the ntext column which it was. I discovered that the solution was...

I am not sure what the problem is even after reading the article. The contents of the ntext is only 724 bytes.

I thought about that and it is a way to go but the app. spec and security issues require the documents to be stored directly on the SQL Server. I don't contro...

I know how to store the document as a blob in the SQL Server using VB.NET. I guess my primary concern is retreiving the blob data and opening it up...

That would be great. So actually you are not running maintenance plans you are running some job that executes a script?