Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 18,926 total)

  • RE: The multi-part identifier "" could not be bound.

    You don't mention that table anywhere so the server can't know what you're talking about.

    You need to add an inner join in the from clause.

  • RE: PF usage Problem

    MasterDB (11/2/2011)


    Thanks for your suggestion dude...

    that really helps me...

    seriously you are master.....:-)

    She's definitely one the the prettiest dude I know :-D.

  • RE: Script for joins

    If you have foreign keys you can build a script based on that.

    Anything else you can think of is just a guess / incomplete picture.

    You could extract all the plans...

  • RE: Indexes after applying a log backup

    If by apply you mean restore. Then those new index will be gone because they don't exist in the log backups you had before creating them.

    Is this theorical only...

  • RE: Scripts: SQLcode displays in 1 line

    Rhox (11/2/2011)


    I've tried to use Notepad, but still 1 line in the code box.

    I use IE9.

    When I'm at work, I will try to use Chrome...

    I have that same problem when...

  • RE: 2008 R2 upgrade advisor error

    opc.three (11/1/2011)


    I found this post through Bing. I am having the same issue. Did you ever find a resolution?

    Google :-D.

  • RE: Identifying who took a database offline

    Ninja's_RGR'us (11/1/2011)


    jared-709193 (11/1/2011)


    Ninja's_RGR'us (10/31/2011)That being said someone's working on permissions right now and they're bloating the logs like crazy (MS dynamics Nav has lots and lots of permissions to grant).

    I...

  • RE: Identifying who took a database offline

    jared-709193 (11/1/2011)


    Ninja's_RGR'us (10/31/2011)That being said someone's working on permissions right now and they're bloating the logs like crazy (MS dynamics Nav has lots and lots of permissions to grant).

    I hate...

  • RE: Need Charindex to Pick Up the Second Instance

    sdownen05 (11/1/2011)


    I appreciate all of you looking out for me. I am realtively new at this, and I am trying to 1) establish best practices, and 2) get the data...

  • RE: Stored procedure performance

    If 4-5 of us combine we can possibly get you 50-75% improvement.

    Normally that happens over 1-2 weeks because of all the waiting between replies.

    95%+ requires to be on site.

  • RE: PF usage Problem

    Usman Butt (11/1/2011)


    Ninja's_RGR'us (11/1/2011)


    @Gail, take over from here. Getting outside my confort zone and no time to research.

    You are indeed outside your confort oops.. comfort zone. 🙂 just kidding,...

  • RE: Reporting services export to Excel

    Try adding the site to safe zone and then putting the security to the lowest level.

    That's the only thing that could block this in IE that I know of.

  • RE: Protecting Intellectual Property - execute access only to SP

    That could work.

    As long as their user don't have view definition permission you should be fine.

  • RE: Updating Stats

    Express12 (11/1/2011)


    adding my 2 cents..

    on SQL 2008 R2, I've setup a job to UpdateStats on 1 database that is 250GB in used space (400 GB alloc) w/ many...

  • RE: Reporting services export to Excel

    Did he upgrade from excel 2k3 to 2k7 or 10?

    I can't think of nothing else!

Viewing 15 posts - 1,561 through 1,575 (of 18,926 total)