is there a question in there somewhere?

another example:

Create Trigger TableName_Insert On TableName For Insert As

Update Tb

Set tb.date_created = GetDate()

From TableName Tb

Join Inserted i on...

thank's Ninja; your example made me realize the third slash ends the domain....

here's my example again tweaked with that realization: this will work for any domain extention now

;With URL_LIST(Id,url)

AS

(

SELECT '1','...

ORDER BY newid() is the way to get randomized data.

you've got to do a few things: first, extract the domain from the urls...in my example, as long is everything...

is there a trigger on the real table represented by "table1"?

for objects...tables,procs or views, a feature of stored procedure is delayed name resolution...of the object doesn't exist at creation time, it still compiles, but will fail at execution time.

so you...

in that case, for that one specific proc, you want that proc to execute as some advanced user ,that really would have access to ADO or the linked server.

then the...

you cannot retreive the password;

but you can pass the crendentials from the domain to the SQL server(is the SQL server on the domain?)

you would get rid of your SQL logins...

if you can install a CLR, that's the way to go; there a re a number of examples out there ,

i personally like fellow poster Elliot Whitlow's contribution on http://nclsqlclrfile.codeplex.com/

one...

it's "kind of" possible with some javascript hacks that are easily worked around by any end user...what are you trying to do? prevent Right Click...View...Source? that would not stop anyone...

Al Cook (11/10/2011)

---

Hi,

If I grant execute permissions to a procedure, do I also need to grant permissions to any underlying tables that procedure uses? Or does the user(s) automatically...

the profile you setup for database mail contains the "from " address;\for multiple addresses, the @recipients parameter expects a semi-colon delimited list of emails:

EXEC msdb.dbo.sp_send_dbmail

...

dave.chapman (11/10/2011)

---

Along those same lines, I want to back up or copy table and data to restore on a different server in a different database. Any good suggestions here?...

here's what i use, that finds FK duplicates regardless of any naming conventions...it uses row_number as suggested:

it also assumes only simple, single column FK, and not multi column FK's

SELECT

'ALTER TABLE...

Narayana Vyas Kondreddi generate insert statements script is overloaded with a lot of parameters;

for example

exec sp_generate_inserts 'myTable', @from="FROM myTable WHERE somevalue > 42"

or

exec sp_generate_inserts 'myTable', @ommit_identity=1,@from="FROM myTable WHERE...