Also the resource kit is supposed to ahve a stress utility, DB Hammer.

Are you looking to stress SQL only or include the application? Not sure that SQL Server stress along tells you much other than a benchmark for different SQL hardware.

I've used Loadrunner,...

Do you mean it actually grows in MB or that the setting gets changed?

Have not gone through this for SQL Server, but that's interesting. Here's the way I did it at a small shop: http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp

I'll ping someone in our...

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.