Viewing 15 posts - 6,436 through 6,450 (of 13,469 total)
daveriya (11/11/2011)
but i know i have selected correct database on...
November 11, 2011 at 9:35 am
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...
November 11, 2011 at 9:32 am
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...
November 11, 2011 at 9:25 am
kick yourself:
EXECUTE @sqlstmt looks for a stored procedure.
EXECUTE (@sqlstmt) executed they dynamic query.
November 11, 2011 at 8:31 am
dammit...tricked into doing homework again, is that what you are saying, my friend? 😀
November 11, 2011 at 8:16 am
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...
November 11, 2011 at 8:14 am
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
...
November 11, 2011 at 8:06 am
NO.
your error is a logical one:
look at your trigger, it says this:
UPDATE SERVERINFO
SET LASTMODIFIEDON = GETDATE()
that...
November 11, 2011 at 8:04 am
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...
November 11, 2011 at 7:02 am
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','...
November 11, 2011 at 6:51 am
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...
November 11, 2011 at 6:35 am
is there a trigger on the real table represented by "table1"?
November 10, 2011 at 12:23 pm
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...
November 10, 2011 at 12:02 pm
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...
November 10, 2011 at 11:55 am
Viewing 15 posts - 6,436 through 6,450 (of 13,469 total)