We will have parameters passed in - I had just planned on using them as follows:

CREATE PROCEDURE dbo.sp_test

@inputParm VARCHAR(100)

...

...

...

select column1, column2, ...

from tablename

where contains(searchfield, @inputParm)

Is that incorrect syntax?  I have...

Interesting.  That would allow us to avoid the issues with re-granting security, as well as the issues with Alter vs. Create in the stored scripts.  Thanks for the input, folks.

We have run into the same issue - some in our company would like to have database names suffixed with the environment name (Prod, Development, etc.) which works better for...

Thanks very much for the assistance! 

Thanks for the info - that is pretty much what I suspected, but couldn't find it in writing.

If anyone else finds it in BOL, I'd still like to know where it...

Billy -

Thanks for the feedback - that will be good to note, as it sounds like a dicey problem to debug.

As it turns out, the problem is being caused by a...

Personally, I prefer to use suffixes: _TB, _VW, etc.

Thanks - I've seen 80% references as a sort of lower threshold for Scan Density - does that seam reasonable?

Edited by - Dave Zahn on 05/05/2003 12:58:58 PM

Greg (or others that may be interested)

This problem seems to have been resolved by applying Service Pack 2 of the SQL/Server Client Tools.

Greg (or others that may be interested)

This problem seems to have been resolved by applying Service Pack 2 of the SQL/Server Client Tools.

Yes, it is a Novell server. Interesting...