If you are contructing the code then you can add the ID number in yourself, e.g.

'SELECT SubjectDisplay FROM PM_RuleSubject WHERE RuleSubjectId = 1'

becomes

'SELECT 4, SubjectDisplay FROM PM_RuleSubject WHERE RuleSubjectId =...

I've done this plenty of times with .NET, but unfortunately at home so I don't have the code with me right now.  Have you tried putting a non-Null value in...

Do you mean you want to make a copy of a SQL table in your Access database?  Or perhaps you want to add the SQL table into Access as a...

Are any other processes running on the server that you don't know about?  For example, I once had a problem when there was conflict between IT backups and jobs running...

I think what you're saying is that you've written code that effectively negates the need for spexecute and params.  The danger then is that your code has missed something that...

To answer your first question: yes, use a table to store the value.  But, that contradicts what you ask in the second question, so sorry about that

Yep, that's what I was going to do, just not got round to it yet 

Nice article

The solution I use is to populate a table overnight with the full syscomments text for each object, across multiple databases.  This table...

"Site owned by Red Gate Software" - it's that easy, surely?

"Site supported" does bring about an image of cheerleaders and raucous fans!

Well said, Jon - saved me the trouble.

I did a bit of dabbling and it seems easy enough to get one of the Globals into a SQL function.  From there,...

Can you implement a standard naming convention then?  If so, you could create a table that maps the folder name (or part of) to the customer code required in the...

Nice article

It was very clear.  To me, at any rate

I think one forum per company/package is too much.  I like the idea of one...

Reporting Services (RS) can run sprocs in a dataset, so in theory you can do whatever a sproc can do.

The issue then is what sort of interface RS can present...

I agree with this too.  It's just using semantics to alter the message, so it should say 'Owned by'.

Or 'Pwned by', which would obviously be hilarious and we could all...