Forum Replies Created

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

  • RE: What, When, Where, How, Who2

    Jason,

    Thanks for the article, good job!

    😉

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 23, 2010 at 12:54 am

    #1183742

  • RE: Upgrade to 2008 from 2005 failed due to sa account being renamed

    sree-879715 (6/22/2010)

    Thank you for your reply !!

    I was able to start the named instance but now I am not able to alter the login name

    I mean I getting error while...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 23, 2010 at 12:19 am

    #1183733

  • RE: Upgrade to 2008 from 2005 failed due to sa account being renamed

    You can start a name instance from command prompt like this:

    net start <InstanceName>

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 22, 2010 at 2:28 pm

    #1183588

  • RE: Dynamic Management Views

    Seems very nice book for DBAs. Thanks for the notice!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 20, 2010 at 2:18 am

    #1182483

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/3/2010)

    Steve Jones - Editor (6/1/2010)

    There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 3, 2010 at 3:25 pm

    #1176228

  • RE: grant permissions

    Or you can use the Grant Select command:

    USE sqlbox

    GO

    GRANT SELECT ON sqlbox TO sam

    GO

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 2, 2010 at 3:41 pm

    #1175607

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (6/1/2010)

    Very cool video. Worth watching:

    http://bit.ly/aY1jlN

    Yep, very cool ...! :hehe::hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    June 1, 2010 at 10:55 am

    #1174918

  • RE: MCITP SQL 2008 DBA

    Read many books or e-books as many as you can read & learn things that is related to the relevant technology, so for the certs about SQL Server 2005 read...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 19, 2010 at 5:36 am

    #1169336

  • RE: New to SQL Server 2008 Linked Servers... need help

    Try to put the remote login and password on Security tab, in the section below like in the attached jpf file...seems problem with your login settings!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 11, 2010 at 7:12 am

    #1165518

  • RE: How to Connect to & Manage ?

    Ok did you check to the services area ...Control Panel > Administrative Tools > Services then search for the SQL Server Browser service!?

    If you find there you should start it,...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2010 at 10:31 am

    #1160584

  • RE: Replace column

    What are you trying to do with this replacement!? It hasn't logic to do like that, how many records do you have in both tables what is the right purpose...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2010 at 10:27 am

    #1160580

  • RE: How to Connect to & Manage ?

    Ok! It is impossible if you have SQL Server Express edition and no SQL Server Browser ... !!!

    Ok! In your machine where you are connected remotely try to find the...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2010 at 10:10 am

    #1160564

  • RE: How to Connect to & Manage ?

    homebrew01 (4/30/2010)

    I'm remotely logged onto the server itself. There is no browser service. The only services related to SQL are:

    SQL Server VSS Writer.

    I don't know how this was setup ......

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2010 at 9:52 am

    #1160545

  • RE: How to Connect to & Manage ?

    Ok! Are you trying to connect in local machine or remote machine !?

    While you have same problem seems that you are trying to connect in remote machine so take a...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2010 at 9:44 am

    #1160538

  • RE: How to Connect to & Manage ?

    If your installation is default way & if you work in your local machine(PC) you can try also like :

    .\sqlexpress OR

    (local)\sqlexpress

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

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2010 at 9:34 am

    #1160532

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