Thank you so much for the help. I'll give it a try.

Yes, I have tried but when I open a new solution there are no templates except "blank solution". I was hoping someone has created this stored procedure with visual studio...

Does anyone know how to add this stored procedure using visual studio 2008?

any help would be appreciated.

Can I compile this using visual studio 2008 express? If not does any one know what I can use if I don't have visual studio 2005?

Thank you for the help. I only have vwd 2008 and it wont work by following the article. I guess I'll have to purchase visual studio to get the stored...

How do I make this work for me? Do I just paste the code as a stored procedure in my sql 2005 database?

Thank you for any help in advance.

Mikek

Can I do this in sql server management express instead of visual studio?