you might be able to add a job which checks for new entries in the view on an hourly basis or something, and have that job insert the new data;

but...

BOL examples show that after the connection info, you need the table to extrac t from, outside fo the parenthesis, and it appears to need 4 part naming conventions;

here'sa BOL...

don't forget the LIKE operator can take some quasi regular expression commands to help determint ehte list:

--every proc/view/table that DOES NOT contain a number.

select * from sys.objects where name like...

i think the rule is this:

if the calling user is NOT a sysadmin, then the proxy account is used.

if the calling user is a sysadmin, then the account being used...

robert i'm pretty sure you have some third party object that is reformatting your SQL;

by default, SSMS is just a syntax-highlighting text editor, with no auto-reformatting as far as...

a parameter cannot be assigned inside the calling statement; just break it up into two lines::

SET @DB = DB_NAME();

EXEC DB1.dbo.test @DB

remember the purpose of the clustered index is to make it faster to find the data; the data does nto necessarily have to be non-unique and not auto-increasing;

does your...

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...