Forum Replies Created

Viewing 6 posts - 31 through 36 (of 36 total)

  • RE: Published Objects

    Hi all,

    I have a question about this sentence in BOL.

    If a type is defined in a database, but it is not referenced in any columns when a publication is...

  • RE: Updating a View

    Hi Hugo,

    Thanks for all of your replies.

    How would sp_refreshview have to choose between QotD.MyTable, Sales.MyTable, Jeff.MyTable, and Hugo.MyTable?

    Yes, that was my initial thinking as well. The way the...

  • RE: Updating a View

    Hugo,

    So to sum it up (and to make sure I understand it correctly)...

    if I move a table to a schema that is:

    not the default schema and is not...

  • RE: Updating a View

    Hey all,

    This is what I ran to try this out.

    CREATE TABLE MyTable

    (KeyCol int NOT NULL PRIMARY KEY,

    ...

  • RE: Updating a View

    Hi,

    I created a view without schemabinding. I then changed the schema of the underlying table. So now, as I understand, my view's metadata needs to be refreshed. I ran:

    exec sp_refreshview...

  • RE: College Life

    I went to school at Middle Tennessee State University. I would like to go back one day and teach there. I played on the ice hockey team and now I...

Viewing 6 posts - 31 through 36 (of 36 total)