Thank you both for your responses. I ended up using nslookup, as it runs much faster than ping does (doesn't have to wait for packet responses). Kathi I really appreciate...

I have an SP now that does the defrag on the database that is passed as a variable to it on any index that has a defrag level about 35...

I don't believe that the recovery model change works. Check out this link: http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=1956

It seems that the only way that changing the recovery model would work, and it's...

I wrote a stored proc that allows you to pass the database as a variable and it will check the frag level of all indexes on every table in the...

In that case let me pose this question--How often do you guys propose reindexing?

database size = 2.5 GB

log is backed up every hour through a maintenance plan.

There is also a maintenance plan that does a full backup nightly of all user databases. Here...

The database is constantly being written to with many small transactions, and it is set to full recovery mode. This log file does this every week, continues to grow until...

Thanks to both of you, I tried both responses, and each works. I'll have to check the execution plan to see which is more efficient. Thanks again.

dynamic SQL is pretty much out here. So there's no way to programmatically change which database is in use? My goal here was to have a script that checked each...

It seems that my problem still remains though, at the bottom of your example you are using the pubs and then the northwind databases, which is where my problem lies,...

So far I haven't been able to find a way to do this. It does seem like the field list is required. The best solution I've been able to come...

Users won't be logged in at all, and don't really need to lock the record for the entire time they are accessing the info for that record, I just have...

Thanks, I appreciate the info. However, I actually found a different way to get around the problem in my program. Sorry, I should have posted that on the topic once...

quote:

---

I've had this one before as well.

I seem to remember changing the enviroment variables for tmp and temp (as Susan says above)

I...

quote:

---

One other trick I've seen sometimes work is to bring up the Client Network Utility (cliconfg.exe) and manually define the alias using...