repeatedly as in within seconds of each other, or you mean you go away, come back after a bit, and get re-prompted for connection info?

if it is the second choice,...

glad i could help and thanks for the feedback!

that link server behavior's a good concept...

matthew.wilson (8/30/2010)

---

Lowell thanks for your reply

Sorry maybe I can be more specific

I can set the columns to datetime though I need the parameter stored in that field to be variable,...

i think because the express edition was installed, and not a default instance, no service is there to answer a connection to 127.0.0.1.

try building a connection string to [127.0.0.1\SQLEXPRESS] instead....

it sounds like you are trying to make one generic proc , instead of multiple procs for specific purposes.

in your table definition, your parameter column is a varchar field, but...

this is fairly simple; are you familiar with the IF EXISTS / IF NOT EXISTS syntax?

I was going to post the whole exmaple proc, but the question struck me as...

JblakTSql (8/30/2010)

---

I am using a trigger to audit use of a database. This is an after update trigger that checks to see if the date lastmodified column in a...

agnesloyola (8/30/2010)

---

I have written an stored procedure that read some records from the remote table on the linked server.Actually whats the problem is When I execute the Stored Procedure ,the...

if only one of the emails got thru, it...

the parameter @recipients for msdb.dbo.sp_send_dbmail expects a semicolon delimited list of recipients; there's no limit to the # of recipients, since it is a varchar(max) definition;

so something like...

I think this is data input validation that needs to occur on the asp page, and not at the server or even SQL server; a simple javascript alert is all...

maybe there is a database trigger that is causuing the issue, and not one on the table itself?

--db level triggers

select * from sys.triggers where parent_class_desc = 'DATABASE'

if it's not in the default trace, which onyl keeps track of "whodunnit" information on DDL stuff for a limited time, and you do not have any other traces in...

I agree the issue is going to be the trigger....show us your audit trigger code; if both fields are money or decimal types, the error raised cannot be from the...

parameter sniffing.

an execution plan is created when the procedure is created, and the SQL engine makes an assumption that since the default values are NULL, the best execution plan should...