Forum Replies Created

Viewing 15 posts - 121 through 135 (of 243 total)

  • RE: how to query current db isolation level

    Use dbcc useroptions

    April 19, 2010 at 7:43 am

    #1153825

  • RE: Database Mail

    Post the error message from the table msdb..sysmail_log

    April 19, 2010 at 7:41 am

    #1153823

  • RE: Services

    joeroshan (4/19/2010)

    No

    thanks 🙂

    April 19, 2010 at 7:38 am

    #1153821

  • RE: Services

    joeroshan (4/19/2010)

    You can use xp_cmdshell.

    xp_cmdshell 'sc qc mssqlserver'

    Note: xp_cmdshell makes your server vurnerable to threats. Disable it once you are done

    Thanks your reply...

    we can read from following command as well...

    April 19, 2010 at 6:58 am

    #1153776

  • RE: Services

    COldCoffee (4/19/2010)

    Oh i get it... hmmm... i dont think we have a way to check that out using T-SQL, BUT I MAY BE WRONG.. probably with little bit of a...

    April 19, 2010 at 5:56 am

    #1153728

  • RE: Services

    COldCoffee (4/19/2010)

    Buddy, dint get ur question fully... u mean, u now need a way to find out if the SQLSERVER and its entourage services are running using T-SQL code, am...

    April 19, 2010 at 5:43 am

    #1153719

  • RE: Job

    Yesterday i have restarted the sql server itself.but still its populating the same error message.

    April 16, 2010 at 4:51 am

    #1152686

  • RE: Job

    Bhuvnesh (4/16/2010)

    sudhakara (4/16/2010)

    I have disabled the job's(copy , Restore & alert) which is belongs to log shipping process at the secondary server.but i am seeing the restore job failed messages...

    April 16, 2010 at 3:36 am

    #1152652

  • RE: SQLCMD

    sudhakara (4/4/2010)

    Hi,

    I am running the query through the command prompt but the result sets is not coming in the proper format. is there any option to show the results in...

    April 16, 2010 at 1:20 am

    #1152611

  • RE: Sql Server Services

    Roy Ernest (4/15/2010)

    Does this server have only SQL Server in it or are you using that same server for other purposes? When booting up, are there lots of things done...

    April 15, 2010 at 10:27 pm

    #1152574

  • RE: Sql Server Services

    Roy Ernest (4/15/2010)

    Did you check the event log to see why it did not start? That is the first step to find out why a service did not start up.

    I...

    April 15, 2010 at 7:09 am

    #1152080

  • RE: SQLCMD

    chandrasekaran.ganapathy (4/5/2010)

    It says that not recognized command.

    Mine is windows authentication. so no username and password.

    what is the version & edition of sql server and windows ?

    April 5, 2010 at 1:51 am

    #1145601

  • RE: SQLCMD

    chandrasekaran.ganapathy (4/5/2010)

    How to set the path?

    c:\cd C:\x.x\x.x\Microsoft SQL Server

    Is it correct?

    Are you connecting from Server or client machine ? what is the version of sql server ?

    path does not matter...

    April 5, 2010 at 1:01 am

    #1145588

  • RE: SQLCMD

    chandrasekaran.ganapathy (4/5/2010)

    Hi I just needed how to execute the query using command prompt. can you please explain.

    check this following URL

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    April 5, 2010 at 12:50 am

    #1145582

  • RE: Maintenance Plan

    Hi,

    Thanks for your reply.

    But i could not find the filed of maintenance steps "order for tasks execute". it help me to find out in which order it has been createded...

    April 2, 2010 at 5:41 am

    #1144667

Viewing 15 posts - 121 through 135 (of 243 total)