Forum Replies Created

Viewing 15 posts - 301 through 315 (of 687 total)

  • RE: Changing report font color

    This is the way I would do it. Your font color switch would use the same data points as the background.

    Say your switch function for the background color looks like...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: Configuring Service Account Privileges for SQL Server

    Good read, thanks for the article.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: Service Pack Strategy

    Here is a KB that will provide some guidance for your rolling patch process.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: Need help on transfer/copy all db objects....from 1 server to another In real time experience way

    Backup/restore and detach/attach will only move the database objects. Jobs, logins, operators, and other instance level objects will need to be scripted and moved separately.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: Help with substring

    depending on your business rules, it could be as simple as a concatenation and replace function.

    select '0'+REPLACE(code,'.','.0') from

    This concatenates a '0' on the front and replaces every '.' with...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: What is wrong with my code?

    DDL scripts, sample data, and expected results would be extremely helpful in troubleshooting your query.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: NT AUTHORITY\ANONYMOUS LOGON - Login Failed - Token-based server access validation failed with an infrastrcture error

    anthony.green (2/23/2012)


    mohammed moinudheen (2/23/2012)


    I had faced a similar issue and it was because of the VSS service which was set to manual and was failing continously after a server restart....

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: Talking baseball

    Oh man! Here we go!

    Spring training is HERE! Bryce Harper thinks he's an all-star for the Nats, Wake retires, Veritek still not signed, Ortiz is on a year for 12...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: If I already have SQL 2008, do I need SQL 2008 R2, since SQL 2012 is due out soon?

    yep, a valid concern. I would cross that bridge when I come to it. No sense in paying money for licensing an instance you won't use or potentially breaking legacy...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: If I already have SQL 2008, do I need SQL 2008 R2, since SQL 2012 is due out soon?

    It is not necessary to go to 2008R2 if you find no pressing reason to upgrade. There are upgrade paths from 2005 and 2008 to 2012, so if you decided...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: 3 node clustering in sql server 2008 R2

    Depending on your licensing you should only need to license the active instances. Now there are rules governing this process so be sure to consult microsoft documentation or give them...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: 3 node clustering in sql server 2008 R2

    oh, same shared disks for two instances... I'm going to say no. Someone with more knowledge might say differently.

    The reason I say no is because the shared disks are removed...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: 3 node clustering in sql server 2008 R2

    I can't tell you what the "best practice" would be but you'd share the same storage with the third node and add it to the windows cluster. You would then...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: 3 node clustering in sql server 2008 R2

    Yes, if node C is allowed to host all the resources, it will host the two instances. Be sure that node C has enough umph to handle running two instances...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • RE: how to get the Domain group name based on the login name

    From a stackoverflow article, OPENQUERY is used to query the active directory

    select *

    from OpenQuery(ADSI,

    'SELECT objectCategory, cn,...

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

Viewing 15 posts - 301 through 315 (of 687 total)