I get the following error message when I try and create the SP:

Server: Msg 156, Level 15, State 1, Procedure prGetList, Line 21

Incorrect syntax near the keyword 'FROM'.

...ehm, yes should have thought of that

Thanks for your help, you made my Friday afternoon

Wow, that is pretty neat

One small problem though regards the fact that nothing is returned for CourseID = 7. So I modified...

Hi Remi,

sorry but I'm not sure I understand how to use the ListTableColumns function? I want to group aggregate values for each CourseID in the Course table. So how do I...

Hi,

not sure I understand the question. If your DB provider supports nested transactions, so will ADO. I have done it in VB6 with SQL Server2000.

What I have observed is that...

OOOPSS

Sorry folks, I had not noticed I was running in Query Analyzer Debug with the "Auto Roll Back" check box ticked.

As soon as it...

Good point! And in relation to my observation the Staging environment is where we would test the production scripts - except that most of the time we haven't got the...

Steve,

one question I have regards the scripts to upgrade production DBs. I have worked on DBs where I tend to completely rebuild the DB for unit testing and QA, but...

It sounds like on the SQL side the transition is pretty straightforward, while on the DBA side a knowledge of UNIX is required.

Thanks for your help.

Hi,

thanks for the quick feedback. If you have worked with both SQL Server and Sybase, how would you rate the ease of switching between the two. Is there a significant...

Sorry, forgot one thing. It appears that I only need to grant permissions to the tables againt which I am executing Dynamic SQL, as shown below.

SET @newsql = N'INSERT INTO...

Hi Frank,

sorry but I don't understand your comment. Does it refer to the entire thread or just to my reply? If so, could you please specify the link of the...

Hi,

If you don't want to pursue the separate server/instance approach, then the only other alternative I know of is to

a) create a custom DB role in the master database...

Hi Yelena,

with regards to the ASPNET account   N'@MachineName@\ASPNET', the configuration instructions for BugNet imply that the IIScomputer may be different from the SQLComputer. In which case the ASPNET account...

Yelena and Steve,

thanks for the feedback. As for the domain setup, here is what I've got

- ASP.NET application running on IIS on my machine

- DB running on SQL Server running...