Viewing 15 posts - 136 through 150 (of 252 total)
You can use FORMATMESSAGE, however :
When trying to call RAISERROR with 107 you get :
RAISERROR (107, 16, 1)
Server: Msg 2732, Level 16, State 1, Line...
Tim C //Will code for food
February 26, 2003 at 4:25 pm
As a general rule I almost add those two statementy to my stored procedures. If I actually want to know the records affected I use @@ROWCOUNT to return that information...
Tim C //Will code for food
February 24, 2003 at 4:24 pm
Hmmmm, when you execut the stored proc in QA does it print out any "(Nrow(s) affected" statements before the actual resultset comes back in text mode? I have seen where...
Tim C //Will code for food
February 24, 2003 at 4:21 pm
If the error is in the sysmessages you can use FORMATMESSAGE
From BOL:
quote:
This example uses a hypothetical message 50001, stored in sysmessages as...
Tim C //Will code for food
February 24, 2003 at 1:17 pm
Interesting... Guard were you using SELECT with "SET NOCOUNT ON"? Did you time just the SET's and SELECT's for the variable assignments or were there other statements in the SQL...
Tim C //Will code for food
February 24, 2003 at 10:28 am
We use a similar technique to what Greg described. There are a couple of
considerations AFAIK :
1) If using single key encryption do not use a HARD CODED string in...
Tim C //Will code for food
February 24, 2003 at 10:22 am
quote:
use SET. It is 3x more efficient even on multiple variable assignment.
pitreconsulting, can you...
Tim C //Will code for food
February 24, 2003 at 8:56 am
The VB code I posted earlier tells you with the
adParamNullable And
adoParam.Attributes = adParamNullable
test. If true, that parameter is
optional and from VB can...
Tim C //Will code for food
February 21, 2003 at 8:35 am
sp_procedure_params_rowset is an extremely interesting proc(actually 2 procs in
one). After looking at its sql, I can not see where it pulls the defaults from,
or if at all it...
Tim C //Will code for food
February 19, 2003 at 9:55 am
quote:
being able to not return a recordset object back to the calling process
Antares, while it...
Tim C //Will code for food
February 18, 2003 at 11:54 am
Hmmmm, I think I will modify my script to error if passing in an = to keep users from setting environ variables. Keep the users from accidentally / maliciously...
Tim C //Will code for food
February 14, 2003 at 12:58 pm
Excellent suggestion antares, as echo would alos not allow them to change it either. BTW my script returns the data from the set command as two columns by splitting the...
Tim C //Will code for food
February 14, 2003 at 12:51 pm
This was written along the same lines as Allens post. http://www.sqlservercentral.com/scripts/contributions/649.asp
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One Windows to bring them...
Tim C //Will code for food
February 14, 2003 at 10:16 am
Reason I typically do this Brian is that I am a NT Admin as well, have been
administering NT since NT 3.1. You are right on all accounts, I would...
Tim C //Will code for food
February 11, 2003 at 2:50 pm
quote:
Do you mean the local Administrators group through the OS or do you mean removing BUILTIN\Administrators from within SQL Server?
Tim C //Will code for food
February 11, 2003 at 1:48 pm
Viewing 15 posts - 136 through 150 (of 252 total)