Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 7,164 total)

  • RE: xp_logininfo run privilege

    pdanes2 (8/3/2011)

    opc.three (8/2/2011)

    From xp_logininfo Books Online article

    Permissions

    Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission granted.

    I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 3, 2011 at 5:53 am

    #1362946

  • RE: xp_logininfo run privilege

    From xp_logininfo Books Online article

    Permissions

    Requires membership in the sysadmin fixed server role or membership in the public fixed database role in the master database with EXECUTE permission granted.

    I think this...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 9:48 pm

    #1362792

  • RE: Group Multiple Rows with Multiple Columns Into a Single Row

    tonyppham (8/2/2011)

    THANK YOU THANK YOU THANK YOU!!!

    You're welcome, HTH 🙂

    I've been working on this for hours and you've solved it in a few minutes!! Do you know if it is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 9:35 pm

    #1362789

  • RE: xp_logininfo run privilege

    The service running as Network Service sounds fine. You are obviously receiving domain info per the xp_logininfo results you posted.

    One more request please.

    Most of the stuff is still fine,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 4:56 pm

    #1362758

  • RE: Group Multiple Rows with Multiple Columns Into a Single Row

    Nice job posting the question complete with DDL, DML and expected results 🙂

    I reworked your DML a bit to provide an actual NULL instead of the string 'NULL'. See if...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 4:49 pm

    #1362756

  • RE: convert CSV file to XML file format based on XSD file using SSIS (SQL Server 2008R2)

    krish.sett (8/2/2011)

    Thanks for your suggestion ,however our team is looking for something Open source.let me know if we have something like XML Spy which is open source.

    I have the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 4:03 pm

    #1362739

  • RE: Deadlock

    You may be able to retrieve the deadlock graph using Extended Events.

    Please read this article:

    Retrieving Deadlock Graphs with SQL Server 2008 Extended Events[/url]

    Note: if you're on 2008 (not R2) then...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 1:31 pm

    #1362558

  • RE: convert CSV file to XML file format based on XSD file using SSIS (SQL Server 2008R2)

    Have you considered using XSLT to transform the file? If you already have an XSD then mapping the input columns to that should be trivial with a decent XML Development...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 1:20 pm

    #1362544

  • RE: Upgrading SQL 2005 to SQL 2008 R2 but staying in 90 compatibility mode

    ALZDBA (8/2/2011)

    Then I see no issue(s) on having it in 90 mode for a transition time span 😉

    If we use compat mode (I'm still trying for a full regression test...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 12:54 pm

    #1362511

  • RE: SSIS parallel processing - which order do things run in?

    It sounds like you want Control Flow functionality inside a Data Flow...I don't think that's how it works 🙂

    Someone may drop in with some magic setting I am not aware...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 12:35 pm

    #1362492

  • RE: Upgrading SQL 2005 to SQL 2008 R2 but staying in 90 compatibility mode

    ALZDBA (8/2/2011)

    I hope you did run the upgrade adviser tool. It will point to potential issues and may be a great to prevent failures and prepare migration projects.

    Don't start without...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 10:17 am

    #1362314

  • RE: SQL Needs to scale out!

    I was going to cite myspace.com too. I heard Christa Stelzmuller speak at PASS 2009 and she was flanked by SQLCAT team members. They were explaining how they use Service...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 10:10 am

    #1362311

  • RE: Using xp_cmdshell to copy files to a sql server on a different domain

    sunshine-587009 (8/2/2011)

    Isn't there something that needs to be done on the boxes themselves since they are different domains? Could there be a syntax to add the Server Name, User ID...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 9:37 am

    #1362267

  • RE: Table lock isolation levels

    You're welcome, HTH 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 9:25 am

    #1362251

  • RE: Upgrading SQL 2005 to SQL 2008 R2 but staying in 90 compatibility mode

    Rich Yarger (8/2/2011)

    I just recently upgraded a database from SQL 2000 (80) to SQL Server 2008 R2 with a process that I created in T-SQL. It was well worth...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    August 2, 2011 at 9:24 am

    #1362249

Viewing 15 posts - 5,251 through 5,265 (of 7,164 total)