Forum Replies Created

Viewing 15 posts - 3,211 through 3,225 (of 9,707 total)

  • RE: Transaction replication lock issue

    I do not think your issue is Replication. I think it is either I/O or bad indexes (or both).

    A few things to look at on your side:

    How wide is your...

  • RE: Audit report

    Not immediately. I'm in the middle of my own urgent project. But I will work on it as I have time. In the meantime, if you know how to do...

  • RE: DROP USER or sp_dropuser

    It works the same way.

    Edit: Just realized you were referring to a system proc, so deleting my previous statement. Google the error you received when you put in the...

  • RE: Concat hard value to each row of Hash Table

    That works wonderfully. Thanks.

  • RE: Add Reference to SSIS 2008 package

    Brandie Tarvin (4/21/2014)


    How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?

    Nevermind. I'm in brain-dead mode this...

  • RE: Add Reference to SSIS 2008 package

    How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?

  • RE: Add Reference to SSIS 2008 package

    Eirikur Eiriksson (4/21/2014)


    Open the Script Task Editor and choose Edit Script. In the VSTA editor, select Project menu and Add Reference...

    😎

    Oh, good grief. I'd never have found that. Thank you.

  • RE: Sorting

    The thing about ordering is that it never works quite the way you expect. The individual columns are all associated with one record, so you can't get every column to...

  • RE: Audit report

    The column you are looking for is type_desc in sys.server_principals.

  • RE: Need Query for Problem

    vignesh.ms (4/19/2014)


    this is not the fine answer & also not mine...

    You were not asked to post someone else's code. You were asked to post what you tried.

    If you are unwilling...

  • RE: xp_create_subdir for non-sysadmins

    Regarding the error... Are you sure that the accounts you are using have FULL CONTROL on the share where you're trying to create the subdirectories?

    Definitely (just for kicks and giggles)...

  • RE: Need Query for Problem

    AWESOME! Thanks for that link. Gail, as always, does wonderful work.

  • RE: sql server and ram

    Perry Whittle (4/18/2014)


    Brandie Tarvin (4/18/2014)


    But none of us recommend you lower the max memory setting unless you know the consequences.

    You would do if your server starts blue screening because...

  • RE: Need Query for Problem

    vignesh.ms (4/18/2014)


    Brandie Tarvin (4/18/2014)


    This sounds like a contest or homework problem to me.

    Should be mixture of all products..

    I'm eagerly waiting for the query....

    Pls try it out..

    Sorry. I don't do other...

  • RE: EXECUTE permission was denied

    If the error is happening because a proc is called inside another proc (or something like that) and you have permissions to see the proc, running this little code snippet...

Viewing 15 posts - 3,211 through 3,225 (of 9,707 total)