Forum Replies Created

Viewing 15 posts - 106 through 120 (of 180 total)

  • RE: User Permission to view Only View not base tables

    John Mitchell-245523 - Wednesday, January 18, 2017 3:13 AM

    Good.  Please post the full results of that query.

    John

    name SchemaOwner
    RRN dbo

    name ObjectOwner type_desc
    View_1 <Schema...

    January 19, 2017 at 5:45 am

    #1923670

  • RE: User Permission to view Only View not base tables

    Sorry my bad its RRN

    January 18, 2017 at 3:04 am

    #1923361

  • RE: User Permission to view Only View not base tables

    John Mitchell-245523 - Monday, January 16, 2017 2:31 AM

    Rechana Rajan - Sunday, January 15, 2017 12:13 AM

    January 16, 2017 at 5:37 am

    #1922949

  • RE: User Permission to view Only View not base tables

    Perry Whittle - Thursday, January 12, 2017 6:06 AM

    Rechana Rajan - Thursday, January 12, 2017 5:25 AM

    January 15, 2017 at 12:13 am

    #1922789

  • RE: User Permission to view Only View not base tables

    Thanks  John and Perry,

    Sorry for the confusion.

    CREATE VIEW [dbo].[View_1]
    AS
    SELECT RRN.ASettings.oid AS Expr1, RRN.BTType.oid, RRN.CSHistory.sId, dbo.CB.MainProfileID, RRN.Void.VoidID
    FROM     RRN.ASettings INNER JOIN
                      RRN.BTType ON RRN.ASettings.oid...

    January 12, 2017 at 5:25 am

    #1922187

  • RE: User Permission to view Only View not base tables

    John Mitchell-245523 - Thursday, January 12, 2017 3:26 AM

    Rechana Rajan - Wednesday, January 11, 2017 11:28 PM

    January 12, 2017 at 3:48 am

    #1922132

  • RE: included Column & Clustering Key

    GilaMonster (1/11/2017)

    Rechana Rajan (1/11/2017)

    If that is the case the lookup for noncluster index will change to new cluster key right?

    ???

    Also if i explicitly specify the cluster key in a nonclustered...

    January 11, 2017 at 4:38 am

    #1921868

  • RE: included Column & Clustering Key

    GilaMonster (1/10/2017)

    Rechana Rajan (1/10/2017)

    My doubt is when we create a Non clustered index the clustering key is already a part of it and then why adding PK column as included...

    January 11, 2017 at 1:03 am

    #1921829

  • RE: Index Foreign Key & Other Indexes

    GilaMonster (1/3/2017)

    Index on foreign keys is a good place to start, but it may not be the best index to have. It's only really needed if rows in the parent...

    January 3, 2017 at 3:51 am

    #1920320

  • RE: Index Foreign Key & Other Indexes

    JasonClark (1/2/2017)

    Yes, it's good practice to maintain indexing. As.

    Performance becomes great on maintaining the relationship on a delete of a primary/unique key.

    also, SQL Server can effectively find the rows to...

    January 3, 2017 at 12:34 am

    #1920307

  • RE: Table copy

    Why cant you create a new table and insert into that all records and delete the unwanted data from original table ? This will make sure the table...

    December 20, 2016 at 12:24 am

    #1918809

  • RE: ANSI_PADDING

    Igor Micev (12/7/2016)

    Rechana Rajan (12/7/2016)

    When i script out tables from my local some have ANSI_PADDING ON and some dont have that mentioned before the create table state. Can anyone help...

    December 13, 2016 at 3:06 am

    #1917530

  • RE: ANSI_PADDING

    Igor Micev (12/7/2016)

    Rechana Rajan (12/7/2016)

    When i script out tables from my local some have ANSI_PADDING ON and some dont have that mentioned before the create table state. Can anyone help...

    December 13, 2016 at 3:05 am

    #1917529

  • RE: SchemaName.ObjectName

    Lowell (12/6/2016)

    yes it could potentially cause problems. best practice would be to go ahead and schema-qualify all the scripts provided to avoid any issues.

    The scenario i would worry about is...

    December 7, 2016 at 4:23 am

    #1916457

  • RE: DBCC TRACEON & Startup Parameter

    Chris Harshman (11/22/2016)

    DBCC TRACEON would need to be manually re-run after a server restart. If you use the startup parameters of the service then it will automatically have that...

    November 22, 2016 at 11:19 pm

    #1914157

Viewing 15 posts - 106 through 120 (of 180 total)