- another reason to split presentation and data.

- convert to the correct datatype asap !

- always do some contenct-checking befor converting.

declare @ParamValue2

if ISNUMERIC(@ParamValue)

begin

  set @ParamValue2 = convert(decimal(12,2),@ParamValue)

  exec dbo.s_Proc...

see my answer at your other post ... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=335083

update your MDAC to at least 2.6. Best is to use the latest version.

http://msdn.microsoft.com/data/Default.aspx

http://msdn.microsoft.com/data/ref/mdac/

Indeed.

- have a look at How to: Rename a Stand-Alone Instance of SQL Server 2005

- technically the sp_dropserver / sp_addserver does the switch. So connections and queries will...

- What's your connection's authorisation ? Is it the same as with QA ?

- I guess your connection is running in "repeatable read"-isolation level ! More locking-related resources are needed,...

 "I don't have access to the Prod DB" That's why you need good collaboration with your productiondba. It eases things to get hold on figures smoothly.

"AWE is enabled" so...

you can create your own mysa-account or use your windows-login with granted sqlserver-sysadmin-privileges !

I didn't disable 'sa' with sql2005 up until now, you'd have to test the effect of it,...

I hope this was the first of a series of usefull answers for this year

just my 2ct

- also keep in mind that many of the "technical" sales people even don't know their app runs just fine with a non-sa sqlaccount.

- you can try to...

maybe you could close your sqlserver's tcp/ip port on your firewall if you don't need external connections, just to delimit your perimeter for investigation.

(Default instances of SQL Server use TCP...

- how is the load of other queries in your system ?

- is this a dedicated sqlserver server ?

- 45 % avg cpu is not that alarming, but gives you...

- Which version of sqlserver are you using ??

- With sql2000 you may want to take a look at user defined functions to accomplish this

- with sql2005 a pivot might...

. means local computer.

.\mylogin is windows-userid mylogin at the local computer. It is not a domainaccount.

Likewize with SSMS you can connect to . meaning you want to connect to the local...

- Did you rebuild the indexes ?

- also manualy run dbcc updateusage and sp_updatestats on all your db or at least on the one where you encounter these alerts.

- try...