daveriya (11/11/2011)

---

no its not in the master database or under system stored procedure.Any other option,while creating it i didint use 'USE DATABASENAME'.

but i know i have selected correct database on...

in theory, we should start using the ALTER USER xxx WITH LOGIN =xxx syntax for fixing orphaned users now, right?

what do you typically do if a USER exists in a...

make sure you didn't create it in the master database by mistake.

it's possible that it is in the "System Stored Procedures" folder if someone ran EXECUTE sp_ms_marksystemobject 'YourProcName' on the...

kick yourself:

EXECUTE @sqlstmt looks for a stored procedure.

EXECUTE (@sqlstmt) executed they dynamic query.

dammit...tricked into doing homework again, is that what you are saying, my friend? 😀

is the server witht eh memory problem one of many on the same virtual server? could it be that instances are eating up 100% of the available memory, and #20...

there's no need to test an EXISTS either...if you are in the trigger, of course there are rows.

this will be what you are after i think:

CREATE TRIGGER Trgr_Update_LastModifiedOn

ON SERVERINFO

AFTER UPDATE

AS

...

NO.

your error is a logical one:

look at your trigger, it says this:

UPDATE SERVERINFO

SET LASTMODIFIEDON = GETDATE()

that...

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