Forum Replies Created

Viewing 15 posts - 8,446 through 8,460 (of 19,560 total)

  • RE: Role to just to view the reports from report manager?

    That user must be. Browser only allows view access.

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

    Check the builtin\administrators group on the local machine. That user is likely a member of a domain group that is...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 10:43 am

    #1388512

  • RE: Deny windows account user to register sql server in enterprise manager

    Jack Corbett (9/29/2011)

    No. If an account is granted login rights to a SQL Server you can't restrict what application they use to connect. At least not within standard...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 10:37 am

    #1388505

  • RE: Role to just to view the reports from report manager?

    is this person a member of the builtin\administrators group?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 10:35 am

    #1388503

  • RE: Database Size increasing

    sql_novice_2007 (9/29/2011)

    When I click the properties of the database I see only 100MB free out of 3.2 GB.

    Still Can shrink the mdf file?

    Thanks.

    Defrag and update stats. But don't shrink.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 10:33 am

    #1388502

  • RE: Database Size increasing

    If you are not running into storage space problems - leave it.

    It is good to have free space in a database.

    Shrinking can cause heavy fragmentation and degrade performance. Only...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 10:33 am

    #1388501

  • RE: Mediocrity Defended

    Truth be told it seems like that is what MS automatic updates does to us

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 10:19 am

    #1388491

  • RE: What’s In Your (Junk) Drawers?

    Charles Kincaid (9/29/2011)

    You said; "Aren’t we all destined to have so much uncategorized stuff and as long as we limit it to one drawer, does it matter?"

    So, getting back to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 9:08 am

    #1388437

  • RE: SSRS URL access issue.

    Pravasis S (9/29/2011)

    SQLRNNR (9/29/2011)

    Also, what version of Windows are you using?

    windows vista, but should it be a problem.

    because earlier It was working perfectly fine.

    I was thinking maybe a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 9:07 am

    #1388436

  • RE: SSRS URL access issue.

    Also, what version of Windows are you using?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:47 am

    #1388419

  • RE: Today's Random Word!

    Daniel Bowlin (9/29/2011)

    Revenant (9/28/2011)

    SQLRNNR (9/28/2011)

    bcsims 90437 (9/28/2011)

    crookj (9/28/2011)

    Ray K (9/28/2011)

    stressed

    Ditto - Not a good week so far.....

    (But I do see the lgiht at the end of the tunnel)

    But is it...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:46 am

    #1388416

  • RE: Are the posted questions getting worse?

    I just had to capture the snake eyes moment.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:46 am

    #1388415

  • RE: Are the posted questions getting worse?

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    Woohoo

    Now, when is your book...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:41 am

    #1388411

  • RE: Troubleshooting SQL Server: A Guide for the Accidental DBA

    Congrats and woot!!

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:41 am

    #1388409

  • RE: SSRS URL access issue.

    When you are able to successfully open a URL from clicking it in the Config tool, have you tried copying and pasting that successful link into a new tab and...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:39 am

    #1388408

  • RE: SSRS URL access issue.

    When you copy the url, are you trying to right click the url and selecting the option "Copy Link" in IE?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 29, 2011 at 8:38 am

    #1388407

Viewing 15 posts - 8,446 through 8,460 (of 19,560 total)