Those are the places I know of where you can retrieve information about the SPID. Well those and using the @@SPID function.

I'm still not sure what you mean by...

I'm not sure I know how to formulate a question that will help me help this guy. Anyone else want to jump in?

I'd guess that they were in different schemas. Was this 2000 or 2005?

I would typically use a stored procedure and set the columns in the stored procedure. You could also have the application pass the values using ad hoc sql. ...

What are you doing in the transaction? Queries are supposed to take locks to maintain consistency.

I'm not sure what you are asking. You can see the SPID as session_id in sys.dm_exec_sessions, sys.dm_exec_requests, and sys.dm_exec_connections.

Michelle Ufford (@sqlfool on Twitter) has an excellent index maintenance script[/url] on her blog[/url]. I'd recommend looking at it.

Seems to work okay, although it does seem to get the coloring (colouring for you Brits) messed up with multiple single quotes.

You are mixing datatypes in the SUM. You cannot sum a string, in your case "0". On your other thread I provided an expression that works. You...

If the parameters should always return a value then I don't why you would get a NULL without an error. A deadlock or lock timeout should return an error...

Sounds like you want something like this:

=SUM(iif((Fields!PERIODID.Value=1) and (Fields!Year1.Value = Parameters!Year.Value), CDbl(Fields!Cost_Code_Actual_Cost.Value), CDbl(0)))

you can convert to whatever datatype you need.

Duplicate post. Please post answers here

It sounds like you just want the count of properties from a specific municipality so your query should be this (note, I changed to standard ANSI join syntax as the...

Some of those items are not available in 2000 (lockout, password change, etc...).

In SQL Server 2005/2008 you should start with sys.server_principals. This will give name, create_date, and modify_date. ...

I can think of 1 reason to keep it in a trigger, someone does an update to that column outside the excel spreadsheet.

As far as performance, the only issue I...