Forum Replies Created

Viewing 15 posts - 1,861 through 1,875 (of 2,007 total)

  • RE: Cannot generate SSPI context

    I have seen this error when a password for a Windows account has expired but has not been changed.

    Can it justify this requirement?

    This only happens on my machine,...

  • RE: Slow backup from SQL Server 2008 between 2 Win 2008 Servers

    If I take backup to local disk, and copy It to the Win2008 Server, the transfer is around 47 MB/s.

    Creating a backup on local disk & then copying...

  • RE: How to automate database scripting

    He didnt suggest speed was the issue either.

    I take it as non-functional requirements (by default). 😉

  • RE: interview

    What's New in SQL Server 2008 R2

    .

    .

    .

    Are you trying to bully OP? :unsure:

  • RE: interview

    In long run it will not help you (& I am personally against use of such options). I would recommend you go with good literature & learn the technology as...

  • RE: How to automate database scripting

    via xp_cmdshell;

    Please follow the discussion... I cringe every time I see a recommendation for xp_cmdshell....

    http://www.sqlservercentral.com/Forums/Topic1186236-1526-1.aspx

  • RE: How to login in sql server using guest login

    Guest is a login not a user

    Sorry for the confusion (user / login).

    I never tried it myself but based on few forums (Others) posts:

    •Enable Guest Login on SQL Server

    •Login (Windows)...

  • RE: How to automate database scripting

    The requirement is:

    I want to script them out and in case of any failure restore the databases from the script and then re-initialise the replication.

    The emphasis is on restore the...

  • RE: How can create more listener?

    Personally, I find this sane.

    Did I say it's insane? 😛 In fact it's not the topic of discussion (for now).

    I would definitely prefer to have the permissions set...

  • RE: How to login in sql server using guest login

    How to login in sql server using guest login...How to test it?

    By default, the database includes a guest user when a database is created. Permissions granted to the guest...

  • RE: sql 2008 permissiong issues

    Execute permissions denied. I am checking again with giving view definition permission on the database.

    Members of the db_datareader fixed database role can run a SELECT statement against any table or...

  • RE: Retiring DB

    Please clarify what is the purpose of retiring a database?

    You couldn't find anything related on the web, because it's not common thing.

    Agree it's not a common term. But...

  • RE: Retiring DB

    ghanshyam.kundu (10/17/2011)


    @DEV: what is the use of doing that, is this means DB tiring?

    I assume OP requested the steps to be followed before making a database unavailable (on PROD box)...

  • RE: Clone a DB and update weekly for read only use

    How about setting up LogShipping (if latency is accepatable) or snapshot replication ?

    Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor...

  • RE: GO vs ;

    Since when is Oracle a good reference 😉

    I am sorry but are you talking about this Oracle :hehe:

    In Classical Antiquity, an oracle was a person or agency considered to be...

Viewing 15 posts - 1,861 through 1,875 (of 2,007 total)