actualy it is a common pitfall to determine "age"/"most recent",.. based on an autonumber !

Add a datetime-column with default getdate() or getUTCdate().

I takes 8 bytes a row, but at least you...

just to add ...

there are special procedures to move master, model, tempdb and msdb.

check out bol or msdn (I cannot recall the KB wright now)

- check out AWE Memory SQL Server Performance Tuning Tips how to handle the /3Gb /pae switches !

- max server...

-- exec sp_configure 'show advanced options',1

-- reconfigure

-- go

- Can you give us the result of exec sp_configure ?

- are the windows eventlogs showing any anomalities ?

- maybe http://support.microsoft.com/kb/815209 can...

Same problem overhere.

I tried http://www.jumpstarttv.com/Media.aspx?vid=70. After 5 minutes it still wasn't showing the episode, only the animated green bar and the ads

- 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...