Forum Replies Created

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

  • RE: Table Variable

    Nice question. Thanks!

    September 4, 2012 at 1:59 am

    #1533141

  • RE: Trigger distribution job on completion of snapshot job

    asir83 (9/4/2012)

    Hey,

    I have one more question, what if the subscriber is a pull subscription & the job is created on different instance?

    How can we call the subscriber job remotely?

    Thanks

    Asir

    I...

    September 4, 2012 at 1:17 am

    #1533133

  • RE: How to log in to sql server ??[If Sa disbaled ]

    Lavanyasri (8/31/2012)

    Hi Team,

    i am unable to log in to sql server, i forget the sa password and my administrator privileges log in is not working . ...

    September 3, 2012 at 5:07 am

    #1532909

  • RE: Failed to Notify Operator via Email

    manju.ccc (9/3/2012)

    1.Database mail is enabled

    2.SQL Server Agent's alert system is configured

    3.Database mail is enabled, and "send test email" succeeds (to the same email I want to send to).

    4.When the job...

    September 3, 2012 at 4:47 am

    #1532903

  • RE: Labor Day 2012

    Michael Lysons (9/3/2012)

    Good, back-to-basics question.

    lol :-D. I am not sure how it was a back-to-basics question, it was absolutely not related to SQL Server basics :-P. Although it was an...

    September 3, 2012 at 4:40 am

    #1532898

  • RE: Trigger distribution job on completion of snapshot job

    asir83 (9/3/2012)

    Since 30-Aug, the snapshot agent is running for more than 15mins, the interval between the snapshot & subscriber job is 15mins, time increase could possibly due to increase in...

    September 3, 2012 at 4:01 am

    #1532886

  • RE: fetch latest status of customer

    This should also work:

    SELECTCI1.CustomerID,CI1.CustomerStatus,CI1.EffectiveDate

    FROMtempdb.dbo.CustomerInfo CI1

    WHERECI1.EffectiveDate= (SELECTMAX(CI2.EffectiveDate)

    FROMCustomerInfo CI2

    WHERECI2.CustomerID = CI1.CustomerID

    )

    ANDCI1.CustomerStatus = 1

    September 3, 2012 at 2:58 am

    #1532867

  • RE: Setting up a new SQL Server 2008R2 Active/Passive Cluster

    Jpotucek (8/31/2012)

    We have several Standalone SQL Server 2005 Servers in Production each with Multiple Instances.

    We will be building out a new SQL Server 2008R2 HA Active\Passive Cluster and I...

    August 31, 2012 at 8:05 am

    #1532402

  • RE: replication or monitor breaks after changing sa password

    Seems like "sa" login has been used while configuring replication. In that case you might need to update the replication passwords too when you change the password for "sa".

    Read...

    August 31, 2012 at 7:44 am

    #1532391

  • RE: Backup in suspended state

    devanandiiway (8/31/2012)

    Hi,

    Please find the hardware details below

    IBM XSERIES_3650 Intel® Xeon™ MVcpu 3.20Ghz, RAM:8GB

    We are taking backup to H: drive whose free space is around 157 GB.

    Have you taken a look...

    August 31, 2012 at 7:32 am

    #1532383

  • RE: Index types 2

    Very good question! Thanks.

    August 30, 2012 at 4:17 am

    #1531776

  • RE: Using Sparse Columns with SELECT ... INTO

    Good question. Thanks.

    August 29, 2012 at 6:09 am

    #1531326

  • RE: Orphaned Users

    SQLSACT (8/29/2012)

    How do I create the Logins with the same SID?

    Is there a process for this?

    Thanks

    Use sp_help_revlogin stored procedure provided by Microsoft at below link to generate the script of...

    August 29, 2012 at 2:01 am

    #1531250

  • RE: AlwaysOn Availability Groups in SQL Server 2012

    Perry Whittle (8/28/2012)

    Thanks for the feedback, please don't forget to rate the article if you found it useful 🙂

    Rated it as 5 stars because that was the limit (it actually...

    August 28, 2012 at 6:29 am

    #1530753

  • RE: Restore Database

    runal_jagtap (8/28/2012)

    Divine Flame (8/28/2012)

    greeshma.patla (8/28/2012)

    Hi ,

    I Dont have .mdf and .ldf files tooo 🙁

    I have only Transaction Log file and Data File

    Is it possible to restore db ?

    Please...

    August 28, 2012 at 6:24 am

    #1530749

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