Hi,

The machine memory is 4.00 GB, and maximun server memory is 3000 MB

Thanks, I change the account that start the sql agent service, but it don´t work.

It is the error:

Executed as user: V3\v3backup. ...n 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp...

Hi,

There is no error. In the subscriptions:

State:

Mail sent to it@domain.com,

but the message didn´t received.

Sorry it isn´t a group account it is a distribution group.

Hi,

I tried as you said, but it did not work.

There is a group account, called it@domain.com, I send a message with Outlook and it was received. But if...

Hi, thanks..... now about Stored Procedures: Can I know which is the last access datetime of stored procedure?

Thanks, but i want create all files in a unique instruction. How can i do it?????

Hi, I load a excel archive, but the sheet name is separated with a space.

How do i it?

INSERT INTO #FILE_EXCEL (CUSTOMER_ID, IDENTIFICACION SELECT ltrim(rtrim([CUSTOMER ID])), ltrim(rtrim(IDENTIFICACION)), FROM...

Thanks, but you don't understand me.

I need taht the first row have all the ITEMS table records as columns and not as rows. Eg, the table Items

Id Name

1 Item...

Ok, thanks....

But now, my problem is:

I have to save this information in a text file, then i need know, which item has been sold.

ie I want that the first row...

thanks so much....

Hi, I execute:

SQL Task 2, Execute SQL Task: Executing the query "EXEC _sp_persons?,

? ,

? ,? ,?" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible...

Hi, it don't resolve my problem, because i need the column value and not the column name itself.

I want in the OLE DB SOURCE editor, write a query...

yes, i'm trying with convert

select convert(varchar, campo_timestamp)

OK.THANKS .....