Glad it helped you build your trigger!

Understanding the relationship between the INSERTED...

darn; i was guessing you were appending a WHERE statement...

ok how about the REPLACE?

this section:

Replace(URL.URL,'{0}',RTRIM(CL.ClientID)) as LOB_CompanyRecord,

uf Url.URL has one row, but CL.ClientID has multiple rows, that oculd cause the...

something is missing;

the error raise typically occurs when you assigning a variable' like SELECT SomeVar = SomeOtherField,

or in a WHERE statement... WHERE SomeVar = SomeOtherField,

JOINS on field = otherfield...

Most best practices for previous version of SQL are still valid, of course, so don't limit your searches jsut to 2008 R2.

there's several series of articles here on SSC for...

i think if you connect to a specific database and run this it might do what you are after:

select 'EXEC sp_help_revlogin ' + name

from sys.database_principals

where type_desc IN ('SQL_USER','WINDOWS_USER')

and...

sounds like a problem with the trigger; paste it here and we can give you some better input on identifying the issue.

this is the lsit of tables used int he query; can you try this update statistics command?

UPDATE STATISTICS [CWT] WITH FULLSCAN

UPDATE STATISTICS [Calendario] WITH FULLSCAN

UPDATE STATISTICS...

hemanth T (5/6/2011)

---

Hi All,

I met a scenario "When a coloumn of a table A is updated trigger should be performed like"AFTER UPDATE" and i need to insert values into table...

rootfixxxer (5/6/2011)

---

Thanks

Like i wrote i didn't had the time to optimize the function...

But the main problem here it's why in 2000 only takes 11 seconds and now in the 2005...

ok now i see it; 5 cursors are being executed for each row;sqlnaive hit it on the issue first; you've got to break it up, or change the logic to...

the devil is in the details.

Can you post the actual execution plan as a .sqlplan xml file, so we can look at it and identify what it's running so...

there's a huge amount of posts and submitted scripts here on SSC that do what you are asking for:

http://www.sqlservercentral.com/search/?q=script+roles+permissions

take a look at any of those and see if they do...

  is the html symbol for non breaking space.

the forum here will convert   into the html space...so you wouldn't see what i was talking about. i had...

you need at least one more column.. if i count everything in the table, there's just one value...in your example you said 680.

bit if you count...group by anothe rcolumn, i...

better:

Select * from TableA where col1 = ReverseOfSomeFunction(@VariableA)

Since the index is on col1, so it would be used and speed things up and would result in an index seek for...