Forum Replies Created

Viewing 15 posts - 76 through 90 (of 243 total)

  • RE: Unable to complete login process due to delay in opening server connection

    Amit Chaudhary (10/18/2008)

    I have a bcp out command running on Server A. The command runs against different Servers ( e.g. B, C, D ). It extracts Data from Tables on...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 7, 2009 at 9:57 pm

    #923071

  • RE: SQL Server Logging

    Jason Shadonix (1/7/2009)

    Anyone know if there is a way to stop SQL from writing certain events to the Windows Event log? Perhaps stopping it from just doing a certain...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 7, 2009 at 9:56 pm

    #923070

  • RE: TSQL to create/alter/remove identity property on column in table

    Eric Klovning (1/7/2009)

    This will give you a list of identity columns.

    SELECT *

    FROM

    INFORMATION_SCHEMA.COLUMNS

    WHERE

    COLUMNPROPERTY -- get columns where is_identity = 1

    (

    OBJECT_ID(QUOTENAME(table_schema) + '.' + QUOTENAME(table_name)) --...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 7, 2009 at 3:03 am

    #922383

  • RE: TSQL to create/alter/remove identity property on column in table

    MANU (1/6/2009)

    The IDENTITY property and the column it's attached to are inseparable, which means that you can't add or remove IDENTITY from an existing column.You can use workarounds, but these...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 6, 2009 at 10:28 pm

    #922315

  • RE: TSQL to create/alter/remove identity property on column in table

    Create table table1

    (

    id int identity(1,1) not null,

    name varchar(50)

    )

    i have created table as above script.

    Now i want to remove identity on id column using TSQL Script .

    Any idea?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 6, 2009 at 6:39 am

    #921734

  • RE: Database Mail Multiple Recipients

    Ed Wyant (5/2/2008)

    What is the method (if there is one) to notify multiple operators of a single job’s run conditions...ie

    Failures, success, or completions? The present database mail configuration works ...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 6, 2009 at 3:17 am

    #921638

  • RE: Correct setup for distrubuted transasctions

    timscronin (1/5/2009)

    I have been having an issue with distrubuted transactions between 2 sql servers. I create a temp table, load the data to the other server, and then update...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:31 pm

    #921575

  • RE: The transaction ended in the trigger. The batch has been aborted.

    sathpon (1/4/2009)

    [font="Arial"][/font]

    Please check any database trigger is ebable or not?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:30 pm

    #921572

  • RE: Prduction DBA

    pavankumarh2 (1/5/2009)

    Dear Friends ,

    I am moving to work on Production support as DBA ,plz any tell me any body what are the common responsibilities of...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:29 pm

    #921570

  • RE: SQL Agent skipping job runs?

    Wesley Brown (1/5/2009)

    Hello all,

    I've got a weird one. It appears that I have had the SQL Agent just skip running a scheduled job task. No failure no job stuck executing...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:24 pm

    #921568

  • RE: Scenarios for Disaster Recovery

    mahesh.vsp (1/5/2009)

    Hi Pals,

    Can anyone suggest few links on disaster recovery scenarios for SQL Server 2005.

    Example : IF "master" database is corrupted what needs to be done.

    .....

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:23 pm

    #921567

  • RE: How can I loop sp_help through for all tables or objects?

    Pete T (1/5/2009)

    I want to create a text file summary of the schematics for a database. Essentially, I want to have what is output for sp_help objectname, but for...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:20 pm

    #921566

  • RE: need a simple query

    PaulB (1/5/2009)

    Paresh Prajapati (1/5/2009)select t1.A,t1.B,t1.C,t2.D

    from table1 t1 inner join table2 t2 on (t1.A=t2.A)

    You may want to test your code, unfortunatelly it doesn't work.

    I think it will be better to...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 10:14 pm

    #921563

  • RE: LogShipping Database

    dakshinamurthy (12/10/2008)

    Hi,

    I am new to this logshipping concept and tried to configure LogShipping for my Database, in this set up i had two servers (Sql Servers). I was not having...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 2:22 am

    #920999

  • RE: Error While retrieving data in Query Analyzer from Excel File

    anita (1/2/2009)

    Hello All,

    Thanx in advance....

    can anyone help me with this problem.

    I had added the linked server excel and trying to retrieve the data thru query

    SELECT * FROM EXCEL...Stock$

    the same process...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 5, 2009 at 2:22 am

    #920998

Viewing 15 posts - 76 through 90 (of 243 total)