sql server new users: Hi all,

I'm trying to migrate an Access database to Sql Server 2005. I downloaded
and installed Sql Server 2005 Express and Sql Server Migration Assistant for
Access.

Worked ok and has complete table migration well, including linked tables.
But queries... no. The problem is that my database has about 600 queries, and
more than half uses parameters!...

As far as I know, the Sql Server views don't permit the use of parameters.
Is there any known solution that don't force me to program all that views as
stored procedures?

Thank you in advance.

You could also use a passthrough to your server using the view on the
server and putting a filter on top, the statement will be evaluated on
the server.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Jens,

Sorry, I didn't understand what's in your mind. Can you explain a little bit
more?

Thanks.
Pedro

[quoted text, click to view]