Interesting ... I ran the same query a few times and have a negative value on only 1 of 4 user databases for one randomly chosen server out of 25....

I feel you pain Philip  ... been there a couple of times before in my career  ...

I've had this problen quite frequently lately (ughh...)

First thing you need to do is download the setspn utility (link below):

http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/setspn-o.asp

Install it on your computer (or server). Next you'll need...

... actually not ... '0x0a' (whatever - I think char(10) ) is still valid in SQL server ... you might still be able to find it in some system sp's...

We use Trend on all of our servers (200+). 25+ of them are SQL Servers and we have had no issues whatsoever (We also implemented by default Brian's Do's/Don'ts).

Just a couple more things to add ...

1) Did you change recovery from 'Full' to 'Simple' on the test server after the restore ?

2) Have you performed a backup/truncate_only on...

I have not worked with any of the third party products that perform encryption. A couple of thought though ... have you searched this web site for 'encryption' ? I've...

Things stop working because unless you specify the actual port, SQL Server will try to establish communications on UDP port 1434 to try and figure oput the port number itself....

FYI --> port 1434 is UDP, not TCP. Your network folks may have blocked it to stop things like the 'slammer' virus (albeit a tad late and not necessary internally)....

agreed !

a few more points to ponder ...

Taking the database 'offline' via attach does not delete the underlying .mdf/.ldf/.ndf files. Unless you manage those files you may have disk space issues...

For those machines with MSDE you will probably need to find out who the vendior was that supplied the software and their tech support number. I've had to perform this...

I'd start using XML format now since MS is going to make it the default in the future (.TDOC .TXLS etc.) ...

One additional note ... this is for 'user' databases only. master, model and msdb cannot be restored to different versions.

Is the domain account for sql server and the agent service defined to SQL ? If they are, then are they assigned to the sysadmin role ? Also, when you...