We recently decided to port our current websites from Access 97 based Databases to SQL Server 7.0 to increase the efficiency and performance of our sites.<BR><BR>We had no problems until it came to importing the queries.<BR><BR>We initially imported the queries as Views, which worked fine except when viewing data from an ntext (memo) field through the query, as the field call would return an empty string.<BR><BR>We then tried importing the queries as Procedures, however this doesn&#039t work either as my scripts can&#039t see the procedures as objects of the DB!<BR><BR>I&#039ve tried and checked the permissions on the procs, and they make no difference...<BR><BR>Please Help!!! <BR><BR>