Try using this query:

EXEC Master..xp_cmdshell 'ipconfig'

If xp_cmdshell access is disabled on the server you will need to enable it.

However I like the idea of using SQLPing.

Here is a good source for the SQL Script:

http://www.sqlservercentral.com/scripts/Miscellaneous/67422/

I go by the motto "Why wait for spring? Do it now!" as we've found once a year is nowhere near the frequency needed for database cleanup. With upwards...

I produce a lot of documentation as part of my job so I'd have to say SnagIt. Also couldn't do without my Notepad ++.

Great movie graphic Steve. At the time the movie had cutting edge technology but it really looks ancient now. Hack the Planet! Hack the Planet! 😛

Excellent topic and some very interesting posts.

Happy Birthday Steve.

What I want most for my birthday is to be able to celebrate my next birthday 😛

Depending on your specific requriements for the database you are reindexing, you may want to consider setting the database recovery model to "simple" to avoid logging all the transactions. I've...

The .DAT file extension is also the default for SQL 6.5 database and backup files. Probably not a good thing to name your SQL 7/2000 backup files with an extension...

This script works great for identifying index logical fragmentation:

/*

 RUN AGAINST APPROPRIATE DATABASE

*/

SET NOCOUNT ON

-- Declare variables --

DECLARE @tablename VARCHAR (128)

DECLARE @execstr   VARCHAR (255)

DECLARE @objectid  INT

DECLARE @indexid   INT

DECLARE @frag      DECIMAL

DECLARE @maxfrag  ...

If you're looking for help with performance monitoring try this free perf mon wizard from Microsoft:

http://www.microsoft.com/downloads/details.aspx?FamilyID=31fccd98-c3a1-4644-9622-faa046d69214&DisplayLang=en

Colin: We've had similar problems when running SQL Server 2000 on laptops (for demo purposes). Try setting SQL Server memory to: Use fixed memory size. In our situation we have 1GB...

During installation you'll come to the following screen. Select this option and you will get the desired collation setting:

All are excellent suggestions however when evaluating a server that I've not seen before I find its best to start with the basics. Find and document the following information on...

I've seen this same thing happen when applying SP4 to one of our test servers. After rebooting the server the version numbers were correct.