Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Creating a View

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-01-28 : 12:26:52
HI I have a View in one database but am having trouble to make a copy of this in a different database.
Thank you kindly,
Adam

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-01-28 : 12:35:43
What trouble are you having? Are you getting any errors while creating in the other database?
Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-01-28 : 13:20:24
No - on more simple level i can't seem to create a view.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-01-28 : 13:43:46
What's the syntax you are trying to use to create the View?
Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-01-28 : 14:41:09
ok i got it to work. Thank you for your help.
Go to Top of Page
   

- Advertisement -