If you're alowed, you could also quickly create a delete-trigger to log all deletes from that table (maybe even narrowing the rows to the ones you want to)  into a audit-table....

after the attatch you'll have to use this :

use yourdb

exec sp_changedbowner @loginame = 'sa' ,@map = 'true'

Also keep in mind EM does not refresh db-owner info ! You'll have to...

how about just adding startupparameters to your sqlserverinstance ?

add -T1204 and -T3605 so deadlock info lis logged into the sqlserver errorlog.

(

Today, your article was one of the featured articles with the newsletter.

Since your filed the article in 2005, things have changed.

Now you have the...

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