Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 7,164 total)

  • RE: partition_id VS. hobt_id

    In SQL Server 2008/R2 the two columns will always have the same value.

    ...and, I am almost sure, in SQL 2012 the same columns again will be just duplicate one another?

    Sorry,...

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

    March 8, 2013 at 8:00 am

    #1594976

  • RE: Creating a reference table.

    brian.geregach (3/7/2013)

    I was thinking of a child table for each of the three columns. Otherwise I'm not sure I understand your question.

    OK, I think I know what you mean...

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

    March 8, 2013 at 7:58 am

    #1594971

  • RE: Today's Random Word!

    JAZZ Master (3/8/2013)

    crookj (3/8/2013)

    SQLRNNR (3/7/2013)

    crookj (3/7/2013)

    Daniel Bowlin (3/7/2013)

    Help

    Support

    Truss

    Tether

    Tie

    Bolo

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

    March 8, 2013 at 7:22 am

    #1594954

  • RE: Issue with custom SSIS powershell task

    That's an error from SQL Doc and would not be related to this.

    Try looking in the Agent Job History log. Right-click the job and select View History.

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

    March 8, 2013 at 7:20 am

    #1594953

  • RE: Create File without xp_cmdShell

    A SQLCLR object can access the file system too, and it would be the lesser of two evils in this case, when compared to enabling xp_cmdshell, but still not ideal....

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

    March 7, 2013 at 9:36 pm

    #1594793

  • RE: modifying a SP

    ntreelevel (3/7/2013)

    Hi my condition is that I already have a sp and I have to add this code and modify the sp so that it returns a column supervisor...

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

    March 7, 2013 at 9:30 pm

    #1594788

  • RE: How to find all column dependencies including triggers?

    arnipetursson (3/7/2013)

    Search for the column name in syscomments

    syscomments is there for backward compatibility only.

    Use sys.sql_modules in SQL 2005 and newer. The definition column contains the T-SQL code for the...

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

    March 7, 2013 at 9:01 pm

    #1594777

  • RE: UPDATE failed because the following SET options have incorrect settings:

    RamSteve (3/6/2013)

    I Created a UniqueIndex on a Test Table with Some condition as below and user were getting error msg as below while updating the test table by using the...

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

    March 7, 2013 at 4:24 pm

    #1594745

  • RE: Creating a reference table.

    brian.geregach (3/7/2013)

    The columns that I think should go into their own table are:

    Priority - a number from 1 - 4

    Assignee - User or group ticket is assigned to

    Category - 1st...

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

    March 7, 2013 at 2:55 pm

    #1594710

  • RE: Creating a reference table.

    brian.geregach (3/7/2013)

    here is the information you were asking for:

    CREATE TABLE [dbo].[Tickets](

    [Ticket Number] [int] NOT NULL,

    [Priority] [smallint] NULL,

    [Assignee] [varchar](25) NULL,

    [Category] [varchar](25) NULL,

    [Vendor Ticket] [varchar](60) NULL,

    [Open Date] [date] NULL,

    [Opener] [varchar](30) NULL,

    [Closer] [varchar](30)...

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

    March 7, 2013 at 2:02 pm

    #1594695

  • RE: Result of dynamic sql with parameteres into a variable

    With proper indexing and query writing that number of rows will not be an issue. I have tables with many billions of rows in them.

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

    March 7, 2013 at 1:56 pm

    #1594691

  • RE: View results into string

    jmceuin (3/7/2013)

    Sorry missed that. And I did more tinkering and just added and additional GROUP BY POPRCTNM to the very end of the statement rather than in the middle and...

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

    March 7, 2013 at 1:54 pm

    #1594689

  • RE: Creating a reference table.

    First off, welcome to SQL Server Central (SSC). This is a great community-site to learn more about SQL Server.

    brian.geregach (3/7/2013)

    I am very new to SQL Server. I have a...

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

    March 7, 2013 at 1:49 pm

    #1594687

  • RE: View results into string

    jmceuin (3/7/2013)

    Also, the GROUP_CONCAT option doesn't work. Apparently that is a MySQL feature not on MS SQL 2008.

    Did you read the CodePlex site I linked to? dbo.GROUP_CONCAT() is a SQLCLR...

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

    March 7, 2013 at 1:31 pm

    #1594682

  • RE: Granting Explicit View Definition Permissions on Stored Procedure to dbo

    charlesd (3/7/2013)

    Yes, that is essentially correct. The developers have dbo rights in the development databases, which implicitly gives them all necessary rights on stored procedures i.e., execute, view definition,...

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

    March 7, 2013 at 1:12 pm

    #1594672

Viewing 15 posts - 1,696 through 1,710 (of 7,164 total)