What errors are you getting? Can you be more specific about the problem?

Just take that select out. Triggers should not return resultsets

There is a cursor because I should read and elaborate...

Since you're using SQL 2008, have you considered FileStream? Best of both worlds - in the filesystem, backed up with the database.

Why are you using a cursor?

A trigger that just does a select from a table is a bad idea and generally frowned upon. Triggers should not return resultsets to the...

Could you explain a bit more what you're trying to do here? What does the trigger do?

As for getting the output of a data modification, check out the OUTPUT clause.

No idea, it's not a standard SQL term or definition. I'd ask for more details.

Paul Randal (5/9/2010)

---

2) what if the I/O subsystem on the (new) mirror is damaged and the rebuild cannot be replayed? What do you suggest as the way forward if the...

sk.sarim (5/10/2010)

---

[font="Courier New"]I think U R using a view to query ur results.

while creating a view use nolock in ur create view statement, and then try it. for ex:

CREATE VIEW...

No, not at all.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic918805-1550-1.aspx

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic918805-1550-1.aspx

2 year old thread...

Profiler (or more correctly server-side trace) is the tool that you use. http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Spam. Reported. No replies please.

Spam. Reported. No replies please.