Viewing 6 posts - 31 through 36 (of 36 total)
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...
January 10, 2008 at 9:23 am
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...
January 9, 2008 at 12:55 pm
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...
January 9, 2008 at 10:23 am
Hey all,
This is what I ran to try this out.
CREATE TABLE MyTable
(KeyCol int NOT NULL PRIMARY KEY,
...
January 9, 2008 at 9:15 am
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...
January 9, 2008 at 8:14 am
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...
January 4, 2008 at 6:25 am
Viewing 6 posts - 31 through 36 (of 36 total)