Try using the sys.dm_exec_requests data management view for the basis information. The system function sys.dm_exec_sql_text can be used to get the currently executing SQL statement.

select sys.dm_exec_requests.*

,db_name(SQLText.dbid)

,SQLText.text

fromsys.dm_exec_requests

OUTER APPLY sys.dm_exec_sql_text(sys.dm_exec_requests.sql_handle) AS...

For error handling, please be sure to read Erland Sommarskog's article at

http://www.sommarskog.se/error-handling-I.html

Based on the article and all of the conditions where error handling cannot be performed, I recommend having all...

Also suggest reviewing this join condition as derived columns cannot use an index.

Original:

on mll.conta+mll.u_subconta = ml.conta+ml.u_subconta

Suggested:

on mll.conta = ml.conta

and mll.u_subconta = ml.u_subconta

Under SQL Server 2005, the add_server_role_member and drop_server_role_member may only be used with event notification and cannot be used with DDL Triggers. The reasoning is that since only a...

Your problem is not clear as "no luck" is not very meaningful. Do you mean that no rows are found ? If so, check the value of the...

select @Nm = 'Age'

select @Null = count(*) from #t1 where (@Nm) is null

As "where (@Nm) is null" will always be false, zero rows will meet the

restriction.

Why are you...

An internet search found the below at http://www.expertsforge.com/Applications/Tutorial-133.asp

Reason for the Error:

NotesSQL expects to find Notes.ini in the \Lotus\Notes directory. If the file is not in this directory, the driver may...

Under SQL Server 2005, you can grant permissions on a schema, such as

GRANT SELECT ON SCHEMA :: dbo to Reader

"This is the site for the software: http://manageengine.adventnet.com/products/eventlog/

I have since been informed by my manager that there is a version for MS SQL Server.

"

Great -

You should be very...

Yes, it is a bad idea as SQL Server will have performance and stability problems if there are any other services that use significant resources.

Optimal is to have...

Be careful about applying Northern Europe name capitialization rules to names of persons from other cultures. For example, notice the capitalization and accents for:

Gustavo Nery de Sá da Silva

José...

Recommend this as a necessity:

The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models by Michael Reingruber, William W. Gregory (Contributor)

Publisher: John Wiley & Sons; ISBN: 0471052906;...

Instead of a JOIN, using a UNION contruct is easier and will run faster. Note that the constants for from/to are set to 0 or 1 appropriately.

SELECTStateCode

,SUM(StateFromCnt) AS StateFromCnt

,SUM(StateToCnt)...

"Is there some way to ensure that the INSERT statement is committed and only the statements in the trigger are rolled back?"

It depends on the statement in the trigger:

1. ...

"there's not mention of an instance name in that path."

Please read my post carefully - "for a default instance" is what I wrote, meaning that a named instance will have...