USE <database_name>;

GO

SELECT name AS SP_name

,SCHEMA_NAME(schema_id) AS schema_name

,type_desc

,create_date

,modify_date

FROM sys.objects

WHERE type_desc LIKE '%STORED_PROCEDURE';

GO

If you can find your...

I guess its OS backup of database files (MDFs & LDFs) either by DETACH or OFFLINE (preferred). It's common in Oracle...

Thank You Kevin 🙂

100% CPU consumption could be result of any activity on Server, not necessarily SQL Server.

Lowell (11/11/2011)

---

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

sami.sqldba (11/11/2011)

---

Thanks again dev but still i am facing a big problem when i am trying to update a single record tigger is updating getdate() for all the records in...

Take out BEGIN & END after AS.

CREATE TRIGGER [ schema_name . ]trigger_name

ON { table | view }

[ WITH <dml_trigger_option> [ ,...n ] ]

{ FOR | AFTER | INSTEAD...

May be FYI (to SSC). 😀

Ninja's_RGR'us (11/11/2011)

---

My fav signature from Lowell =>

Lowell

--------------------------------------------------------------------------------

--There is...

It's obvious that we will save processing time that SQL Server will take for string functions.

Ninja's_RGR'us (11/11/2011)

---

schumichen (11/11/2011)

---

the table contains more than 100.000 urls....with every ending that is possible...

maybe its better to make a new column with the domains ?

like

id,url,domain

so would that be easier...

If you don't specify ORDER BY with TOP , the resultset order would be uncertain (random) ONLY.

schumichen (11/11/2011)

---

the table contains more than 100.000 urls....with every ending that is possible...

maybe its better to make a new column with the domains ?

like

id,url,domain

so would that be easier to...

Most Welcome 🙂

DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server automatically creates and manages these tables. You can use these temporary, memory-resident tables to...