Problem with SQL services

When I reset or restart windows, the services mssqlserver
and the agent dont start.
I have this services configured with a administrator
domain user in the log on properties and for some reason
this services dont authenticate the password user I
received a error with the login but If I will to the
properties services and write the same password, the
service start.
The question is why dont start this services
automatically?
I change the password of this user and I have the same
problem.
My s.o. is win2000 sp4 and sql 2000 with sp3 in english
and this machine is a member of a w2000 domain.
I wait taht us understand me.
Regards,
Roque.In the properties of SQL Server (can be accessed from Enterprise manager by
right clicking on server), make sure "Auto start SQL Server Agent" is
checked.
ashish
"Roque Catanese" <anonymous@.discussions.microsoft.com> wrote in message
news:900e01c3e9cb$ab25f410$a601280a@.phx.gbl...

quote:

---

> When I reset or restart windows, the services mssqlserver
> and the agent dont start.
> I have this services configured with a administrator
> domain user in the log on properties and for some reason
> this services dont authenticate the password user I
> received a error with the login but If I will to the
> properties services and write the same password, the
> service start.
> The question is why dont start this services
> automatically?
> I change the password of this user and I have the same
> problem.
> My s.o. is win2000 sp4 and sql 2000 with sp3 in english
> and this machine is a member of a w2000 domain.
> I wait taht us understand me.
> Regards,
> Roque.

---

Problem with SQL services

When I reset or restart windows, the services mssqlserver
and the agent dont start.
I have this services configured with a administrator
domain user in the log on properties and for some reason
this services dont authenticate the password user I
received a error with the login but If I will to the
properties services and write the same password, the
service start.
The question is why dont start this services
automatically?
I change the password of this user and I have the same
problem.
My s.o. is win2000 sp4 and sql 2000 with sp3 in english
and this machine is a member of a w2000 domain.
I wait taht us understand me.
Regards,
Roque.In the properties of SQL Server (can be accessed from Enterprise manager by
right clicking on server), make sure "Auto start SQL Server Agent" is
checked.
ashish
"Roque Catanese" <anonymous@.discussions.microsoft.com> wrote in message
news:900e01c3e9cb$ab25f410$a601280a@.phx.gbl...
> When I reset or restart windows, the services mssqlserver
> and the agent dont start.
> I have this services configured with a administrator
> domain user in the log on properties and for some reason
> this services dont authenticate the password user I
> received a error with the login but If I will to the
> properties services and write the same password, the
> service start.
> The question is why dont start this services
> automatically?
> I change the password of this user and I have the same
> problem.
> My s.o. is win2000 sp4 and sql 2000 with sp3 in english
> and this machine is a member of a w2000 domain.
> I wait taht us understand me.
> Regards,
> Roque.

problem with sql mail

i have configured sql mail to send emails to outlook with exchange server
running with outlook ... but the problem iam facing is that although the
option of "sent messages to the sent items folder " is cliecked under the
sql agent mail and also in the outlook but still any mail that goes through
sql mail is delivered successfully to the recipient but does not go the sent
items folder of outlook
would appreciate any help on this thnaksIf you are running SQL Server 2000, SQL Mail for SQL Server
2000 does not save a copy of sent messages in the Sent Items
folder. If you need a copy of the messages, you need to cc:
them to an exchange account and create an Outlook message
rule that routes these message copies to the Sent Items
folder.
For more info, refer to:
INF: Common SQL Mail Problems
http://support.microsoft.com/?scid=315886
The section: Q7: Why do I not have any sent messages in the
Sent Items folder explains this issue.
-Sue
On Sun, 7 Mar 2004 15:09:13 +1100, "afsheen"
<afsheenj@.hotmial.com> wrote:

>i have configured sql mail to send emails to outlook with exchange server
>running with outlook ... but the problem iam facing is that although the
>option of "sent messages to the sent items folder " is cliecked under the
>sql agent mail and also in the outlook but still any mail that goes through
>sql mail is delivered successfully to the recipient but does not go the sen
t
>items folder of outlook
>would appreciate any help on this thnaks
>

Problem With Result Set in SQL Task

Hello,

I have a SQL Task configured to return a single row, and a single column value. The SQL Statement looks like this;

SELECT MAX(InvoiceDate) AS InvoiceDate
FROM dbo.DailySettlementData

The statement parses without a problem. In the 'Result Set' of the SQL Task I have the following;

Result Name; InvoiceDate, Variable Name; LatestTableDate

'LatestTableDate' is of type 'DateTime' (and I'm wondering now if this needs to be of type 'Object')

I need this MAX(InvoiceDate) value in a later step that checks this value against another date type variable.

I'm not getting the result I expect. Do I have the variable for the result set in the SQL Task set up correctly?

Thank you for your help!

cdun2

I assume that the variable name is "User::LatestTableDate", right?

Otherwise that looks fine. It doesn't need to be an object datatype. You can try a result name of "0" instead of "InvoiceDate" and see if that returns anything different.|||

Phil Brammer wrote:

You can try a result name of "0" instead of "InvoiceDate" and see if that returns anything different.

One of my variables needed to have 'EvaluateAsExpression' set to True. Now it works fine.

A couple of questions related to working with SSIS in Visual Studio;

I'm looking for some way to 'watch' my SSIS variables in the 'watch' window. I thought this would be available from the Debug or Windows menu in Visual Studio 2005, but I don't see it.

While I'm on the subject of Visual Studio, I've noticed that all of my packages related to a specific project will open when I try to debug just one package. Why does that happen? The packages are independent of each other.

Thank you again for your help.

cdun2

|||

cdun2 wrote:

While I'm on the subject of Visual Studio, I've noticed that all of my packages related to a specific project will open when I try to debug just one package. Why does that happen? The packages are independent of each other.

Close them before saving the project and closing it. It will open whatever you left open the previous time.|||

cdun2 wrote:

I'm looking for some way to 'watch' my SSIS variables in the 'watch' window. I thought this would be available from the Debug or Windows menu in Visual Studio 2005, but I don't see it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250573&SiteID=1