Was this cable/IP added since the last time SQL Server was restarted or the server rebooted? I've had issues where the listener for SQL Server doesn't dynamically pick up new...

Also if the shrinkfile doesn't work, try this:

http://www.sqlservercentral.com/scripts/contributions/26.asp

try "truncate xxx with no_log", then shrink the log and run a backup.

Since slammer, 1434 has been turned off in many places and discovery has been tough. SMS has worked well here in querying for SQL services.

Are you looking for free or something that you purchase? BMC, NetIQ, others have pay products. I used MRTG, but had help setting it up and it worked beautifully.

Whoops

No native way. 4 methods I know of.

1. Write a script to pkzip your .bak file.

2. Use SQL Litespeed (Allen's link above). We use that here at SSC and at...

Use a PErformance Monitor alert. You can alert on db getting a certain size.

If you can connect on certain ports and not others, some type of packet filtering is occurring. Most likely a firewall.

Doh! , done that myself. Thanks for the update.

If you check what's in sysservers now, you should see

   server/instance

in a row. Don't forget to add the ", local" to the addserver call.

I'm guessing that there can only be 8 databases in a particular transaction. I don't see anything in BOL relating to this. Does the update cross 8 dbs?

What is on the line where the error occurs? Can you post the connection string? (change teh server name, user, and pwd)

wc is a unix utility that will word count. I'd bet you could find something like this for windows and send your field through it and get a result back.

I've seen similar issues with data corruption. Or QA having issues rendering the result set.

Does select count(*) work?