Re: sqlservr
From: David Gugick (davidg-nospam_at_imceda.com)
Date: 09/24/04
- Next message: Wayne Antinore: "Re: cannot write to sql 2000 database after about 2 hours uptime"
- Previous message: Mike Lackey: "Maintenance Plans and Integrity checks"
- In reply to: CMLC: "Re: sqlservr"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 11:10:41 -0400
CMLC wrote:
> We have a MSA1000 storage and he had problems with the
> controller's firmware version affecting SQL Server. We
> made a firmware upgrade and aplied patch 8.00.973 on SQL
> Server from Microsoft Support to solve the problem but we
> need to track if we are getting problems with other
> hardware components, that's way we installed the new fix
> and must activate flag 818. When i tried to activate the
> flag i had the problem that i posted, how can i activate
> the flag in cmd line ? how can i make shure that the flag
> is on ? Hope this give you an idea of my situation here,
> i'm not shure as well that i'm thinking correctly on this
> issue, that's way i posted here my situation to have some
> feedback about it :)
>
> By the way, i notice that you are from imceda, i have been
> trying Coefficient for the last week, i like a lot the
> tool.
>
> Thanks again, i will try out different sintax in the cmd
> line. If you have other tips, they are welcome :)
>
> CMLC
>
>> -----Original Message-----
>> CMLC wrote:
>>> Hi David,
>>>
>>> Thanks for the answer, but how can i say that the flag in
>>> on ?? for instance if i try
>>> Net Start MSSQLSERVER -T355363667
>>> the servers runs ok as well
>>>
>>> Thanks
>>>
>>
>> You can also use the sqlservr.exe application. It's possible the
>> trace flags can only be set by calling the EXE directly (not sure).
>> See that topic in BOL for the command-line parameters.
>> sqlservr [-sinstance_name] [-c] [-dmaster_path] [-f]
>> [-eerror_log_path] [-lmaster_log_path] [-m]
>> [-n] [-Ttrace#] [-v] [-x] [-g number] [-O] [-y number]
>>
>> Can't you just create a shortcut to the application and run the
>> shortcut? Are you trying to start the sql server remotely? Please add
>> more details. As you indicated in your orignal post, you seem to
>> already know about the command-line. What trouble are you having?
>>
>>
>>
>> --
>> David Gugick
>> Imceda Software
>> www.imceda.com
>>
>> .
Maybe I missed it in your post, but what error are you seeing when you
start SQL Server from the command-line?
If you are only looking for confirmation the trace flag status, use
DBCC TRACESTATUS (an example):
DBCC TRACESTATUS(3205)
dbcc traceon (3205)
DBCC TRACESTATUS(3205)
dbcc traceoff (3205)
DBCC TRACESTATUS(3205)
-- David Gugick Imceda Software www.imceda.com
- Next message: Wayne Antinore: "Re: cannot write to sql 2000 database after about 2 hours uptime"
- Previous message: Mike Lackey: "Maintenance Plans and Integrity checks"
- In reply to: CMLC: "Re: sqlservr"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
