What does ur colleague says is wrong about using stored procedures? What does he/She says as an alternative to stored procedures?

Could u post ur table description(CREATE TABLE statement) and possibly 3 insert statements with your current records in the table? I t would be lot more faster that way so...

R u looking for something like this:

[Code]

SELECT CASE PeriodID WHEN 1 THEN 'Period1'

WHEN 2 THEN 'Period2'

WHEN 3 THEN 'Period3'

ELSE 'Other'

END AS Period

FROM dbo.tblCmPeriod

[/Code]

U can use sp_who2 or SELECT * FROM SYS.sysprocesses WHERE SPID > 50 (For SQL 2005) to know all active/passive connections connected to your Sql server.

Yes u can force a failover to ur mirror server while your transaction is open. When u try to do that, SQL server will ask u that do u want...

Is this ur Live or Test Database?

Although U must have tried this but I will start from basics.

(A) Is it possible to have dirty reads on some of the transactions using nolock in your application...

You can't UPDATE identity column using update command, but u can reseed the value using DBCC CHECKIDENT.

Can u give examples of the things that r not working correctly?Thanks

I just wrote this query, its in its crudest form so it does kind off what u want:

IF EXISTS (SELECT * FROM tempdb..sysobjects

WHERE id = object_id(N'[tempdb]..[#tempTest]'))

drop table #tempTest

create table #tempTest...

"Guest" user account has been there since SQL 6.5 days. It was used in SQL 2000 for some system functions and needed to be maintained for SQL to function properly....

Is C2 tracing enabled on ur SQL server?

Thanks for that....

Is TCP/IP enabled in ur client protocols for your SQL 2008 Sql Server Configuration Manager? under SQL Native Client 10.0 Configuration?

Have u tried statement terminator at the end of your SQL statement ";"

i.e. UPDATE tabname SET colname = crap;

Haven't r SQL in Access for long time, but I was just...