OK, rewriting your query, just so we can break apart some items...

is there the same performance diff. using the following query with/without firstname?

SELECT AL2and3.vch_shortname, AL2and3.i_event_id, AL1.i_users_id, AL1.vch_lastname, AL1.vch_firstname...

Yeh Noel, I hear ya. Just wanted to maybe give you some "ammo" or thoughts that might help.

Is the statement hard coded into...

Are you talking about when the identity value reaches the max value of the data type?

or will SQL functions like @@IDENTITY, IDENT_CURRENT() or SCOPE_IDENTITY( ) be of help.

2 WEEKS VACATION all at one time! Must be nice

I've been following this thread... was thinking maybe some form of the following may be usable...

-- In T-SQL

Create Table TestTable (ID Int, TestF Bit)

-- Then change:

--   Insert...

Yeh, sorry, that's my own build in SP, does some intermediate logging work etc.

Glad the "jist" of the idea worked for you.

It only makes me work 2 extra hours each day, It must drive Frank nuts , He's putting in an extra 8 hrs of...

In regards to

If you have a link server entry, you can try something like...

LinkedServer.Master.dbo.sp_ExecuteSQL N'Exec SyJobExecute_sp ''JobName'', 0'

On SQL Server Centrals home page.

Todays is "Indexing Strategies". I guess they call them "Headlines", my bad

I definitly happens when going to the page pointed to by the emailed "Reply Notifications" & "Active Posts" page.

The following line in your code

   SELECT @type EXEC(@cmd)

is actually 2 commands, not 1 command that assigns a value to @type.

Try changing to something like ....

.....

--test input against type

SELECT...

See prior recent thread...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=93526#bm93703

I hope the address paste works ok, I used the new forum search with "sp_executesql" key word, and T-SQL as only section to search. Worked great...

Any update on the forum subscriptions yet?