Forum Replies Created

Viewing 15 posts - 166 through 180 (of 224 total)

  • RE: MSQLSERVER, Status is Starting, but doesn't Start

    Please post the error log information of the server.

    You can find the error log from the following folder.

    C:\Program Files\Microsoft SQL Server\MSSQL10_50\MSSQL\Log this is applicable if you server version...

    January 24, 2012 at 11:40 pm

    #1438095

  • RE: Stored proc help

    gmamata7 (1/24/2012)

    Hi,

    I never used the OUTPUT parameter before. I trying to use an existing procedure and it has OUTPUT parameter.

    what value should I give for OUTPUT parameter @retval

    SET @retval =...

    January 24, 2012 at 9:35 pm

    #1438078

  • RE: Createding table simple question

    kirkdm01 (1/24/2012)

    When creating a table

    how do make the FieldID auto increment

    Create table(

    PostID int Primary auto increment

    ...

    )

    You are refereing to identity columns.

    Please google about identity columns.

    Create table RunningId (intSlno...

    January 24, 2012 at 9:26 pm

    #1438076

  • RE: Why doesn't this work?

    raotor (1/18/2012)

    I think it should've worked now. There should be a .rar format attachment on this post with the Result_1 and Result_2 report files.

    I think this is the property of...

    January 18, 2012 at 6:15 am

    #1435188

  • RE: Why doesn't this work?

    raotor (1/18/2012)

    Hello,

    Just a simple but puzzling question; When I execute the following T-SQL the @MaxLen variable appears to hold the desired value, but when used within the LEFT clause doesn't...

    January 18, 2012 at 3:08 am

    #1435077

  • RE: another question

    anilr71 (1/18/2012)

    i have 10 users ..

    they r connected to database...

    so i wanna check one user of the IP ADDRESS

    how to see..

    is there any command to see ..

    You can...

    January 18, 2012 at 12:43 am

    #1435005

  • RE: Automatd way to fetch specific data

    waseem.shahzad 45937 (1/17/2012)

    Hi guys!

    We have multiple servers and need to fetch...

    January 17, 2012 at 2:02 am

    #1434457

  • RE: Change SA password in SQlserver 2008.

    baabhu (1/17/2012)

    Ignacio A. Salom Rangel (1/17/2012)

    baabhu (1/16/2012)

    Thanks for the link.

    Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

    le user mode. Only one administrator can connect at this time.

    I...

    January 17, 2012 at 1:22 am

    #1434449

  • RE: Change SA password in SQlserver 2008.

    Ignacio A. Salom Rangel (1/17/2012)

    baabhu (1/16/2012)

    Thanks for the link.

    Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

    le user mode. Only one administrator can connect at this time.

    I am...

    January 17, 2012 at 1:10 am

    #1434448

  • RE: Change SA password in SQlserver 2008.

    Thanks for the link.

    Login failed for user 'XXXXXX\babu.balakrishnan'. Reason: Server is in sing

    le user mode. Only one administrator can connect at this time.

    I am also added in the local...

    January 16, 2012 at 11:43 pm

    #1434422

  • RE: Restore failure on Log Shipping Secondary

    Hi Josh,

    What is the fix for the issue?. Does the restart helped you or you reinitiated the log shipping from scratch?

    I am curious to knew about the result....

    January 2, 2012 at 8:30 pm

    #1427532

  • RE: Question about SQL Server Query

    This is a simple join statement.

    Select Emp.[Employee Code], JobCode, FromDate from Employee Emp Inner join Position Pos on Emp.[Employee Code] = Pos.[Employee Code]

    Please read through the link given below....

    January 2, 2012 at 7:59 pm

    #1427528

  • RE: sql Managemt studio 2008 - View code "Explosion"...

    What is your question?. Can you use select statement in the underlying views? The answer is yes.

    I can have view 1 and view 2. They combine to form view...

    December 28, 2011 at 3:39 am

    #1426006

  • RE: Table level disable or locking Script?

    Ananda,

    My immediate thought you may have mutiple servers connected through SSMS. Your create user scripts executed in different server and you are trying to deny the access in different...

    December 26, 2011 at 11:20 pm

    #1425565

  • RE: Christmas Fun

    Good One Steve. Merry Christmax.

    -- Babu

    December 26, 2011 at 8:19 pm

    #1425550

Viewing 15 posts - 166 through 180 (of 224 total)