Add Startup Parameters

I need to add the DBCC Traceon (1204) to my SQL Server
startup parameters?
Please help me completing this task.
Thank You,
DanThis can be done in Enterprise Manager, and I explained it here:
http://vyaskn.tripod.com/administration_faq.htm#q14
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:1507001c3fa25$a4fb1c40$a401280a@.phx
.gbl...
I need to add the DBCC Traceon (1204) to my SQL Server
startup parameters?
Please help me completing this task.
Thank You,
Dan

Add Startup Parameters

I need to add the DBCC Traceon (1204) to my SQL Server
startup parameters?
Please help me completing this task.
Thank You,
DanThis can be done in Enterprise Manager, and I explained it here:
http://vyaskn.tripod.com/administration_faq.htm#q14
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:1507001c3fa25$a4fb1c40$a401280a@.phx.gbl...
I need to add the DBCC Traceon (1204) to my SQL Server
startup parameters?
Please help me completing this task.
Thank You,
Dan

Add Startup DBCC Traceon (1204)

I need to add the DBCC Traceon (1204) to my SQL Server
startup. Everytime my server is rebooted I have to
reapply the DBCC Traceon (1204) statement.
I would this to applied each time my server is rebooted.
Please help me completing this task.
Thank You,
DanYou could do this using Enterprise Manager. See
http://vyaskn.tripod.com/administration_faq.htm#q14 for more info.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:14daf01c3fa1f$d06a1850$a001280a@.phx.gbl...
I need to add the DBCC Traceon (1204) to my SQL Server
startup. Everytime my server is rebooted I have to
reapply the DBCC Traceon (1204) statement.
I would this to applied each time my server is rebooted.
Please help me completing this task.
Thank You,
Dan

Add Startup DBCC Traceon (1204)

I need to add the DBCC Traceon (1204) to my SQL Server
startup. Everytime my server is rebooted I have to
reapply the DBCC Traceon (1204) statement.
I would this to applied each time my server is rebooted.
Please help me completing this task.
Thank You,
DanYou could do this using Enterprise Manager. See
http://vyaskn.tripod.com/administration_faq.htm#q14 for more info.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:14daf01c3fa1f$d06a1850$a001280a@.phx
.gbl...
I need to add the DBCC Traceon (1204) to my SQL Server
startup. Everytime my server is rebooted I have to
reapply the DBCC Traceon (1204) statement.
I would this to applied each time my server is rebooted.
Please help me completing this task.
Thank You,
Dan

AD Startup script - Integrated Auth SQL 2000

I have a VB Script that will be running on all workstations on a
domain from the AD Startup script Global Policies. The script uses ADO
integrated authentication.
This script needs access to a database on SQL Server 2000
I added "Domain Computers" computer group to the DB for access but the
script fails.
Error Opening Connection
Error Description: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.
Is it possible to use integrated authentication from a startup script?
The script works fine when I use a sql username/pass but its sensitive
info so I want don't want the username/pass passing clear text.
We will be setting up two way encryption, but would feel safer with
integrated.Once the user has logged onto the machine, if they run this particular
script does it also fail?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.