Thanks for answers.

I call this procedure from VFP with EXEC stocProdStive [parameter]. It's return less then 100 rows

Unless you add structures to the #Temp table that the...

Is it dynamic SQL? Dynamic SQL runs under the individual user's authority, not the SP (it is treated as a completely seperate batch). If so, see what you can do...

I've never used full text search. My only experience with it is reading stuff here. But from that your guess may be correct. I ultimately don't know of any way to do it...

Yes. Easily. Table permissions are entirely different than EXECUTE permission on stored procedures. Simply don't grant any INSERT, UPDATE, or DELETE authority to any tables in the database and then...

Yes it does. Try the following with and without the set nocount on line commented out.

declare @ErrorCd int

raiserror ( 'test', 12, 12 )

set nocount on

set @ErrorCd = @@Error

print @ErrorCd

Try out the following:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=132980

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=133911

The opposite direction:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=133646

The reserved space (2.5 GB) is the amount of space allocated to the file, but not actually used.

0.9 GB of space is allocated to the data and 1.6 GB of...

This probably isn't entirely what you were hoping for, but in BOL if you type in the number in Index search you can find the 15000-15999 error state range. Looking...

Is the "large transaction" crossing multiple batches, or is it a single batch that can generate many inserts? If the latter, is it many individual inserts, or an INSERT INTO...

Were the local variables the exact same type as the parameters? I assume when you checked the execution plan you used an EXEC of the SP instead of copied SQL,...

He posted this question in triplicate or more. I gave basically the same response which was at the following post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=138739#bm138752

The bulk load process described by David has advantages, but the one issue I see is that the select distinct part filters duplicates from the load batch without respect to...

That's unfortunate news. I was obviously hoping that there was some attempt to notify the client that the connection was terminated and I've obviously never had occasion to test this...

This first one is, well, crude and rude but kind of elegant in a way. When the client wants the record have it make the request using a seperate connection...

Um, sure. Click on the database containing the Stored Procedure (or any of its subcomponents), go to the "Tools" menu option, choose "SQL Query Analyzer", write an EXEC line for...