Re: How to get the sql statement of a view? (by running a query or from ado.net)

"Philipp Post" <Post.Philipp@[EMAIL PROTECTED]
> wrote in message 
news:d4abd6b4-af00-455d-ae1d-7f2978416cac@[EMAIL PROTECTED]
> John,
>
> if you are using C# you might want to look at this artice:
>
> http://weblogs.sqlteam.com/billg/archive/2005/12/24/8613.aspx
>
> All source code is supplied for this solution. It sup****ts scripting
> out all database objects on SQL Server, what also can be done with the
> SQL Server Management Studio or the Database Publi****ng Wizard from
> Microsoft.
>
> Brgds
>
> Philipp Post

Thanks Philipp,

I like Toms solution best, well if i can get it to work with views...but I

have had a look through this and it looks like it might be useful...

Thank you
John Sheppard