ok, here's another I wrote that is absolutely free and open source:

http://www.codeplex.com/scriptdb

you can use it to script out all database objects from the cmd line. it's nice to automate...

I wrote a tool called sqlspec for documenting databases in SQL Server and every other DBMS of note. some people like it. 🙂

details in my sig below.

EDIT: this...

seems like a job better suited for this:

http://support.microsoft.com/kb/316005

sure there...

I predict a landslide victory for option 1 in this poll.

why on earth are you running 2000 SP1?? that's ancient. plus it's vulnerable to SLAMMER.

you should upgrade. 2000 is up to SP4.

select name, create_date from sys.databases

I think this is a nice little article illustrating a good, systematic method for attacking complicated queries:

http://weblogs.sqlteam.com/jeffs/archive/2007/04/30/60192.aspx

Jeff Moden (4/9/2008)

---

Heh... my very first question is "How do you get the current date and time using a query". Believe it or not, about 1/4 of the candidates...

are you sure the server is running? are you able to connect from the same client machine through another method using the same credentials, such as SQLCMD or SSMS?

I am judging from the section on that page entitled "Manageability".

all the same boxes are checked for standard and enterprise in this section. you don't downgrade until workgroup, when...

I telecommute one day a week on average. no desk sharing. without RDC I wouldn't be able to do it.

It's just like I'm at work except...

should be no difference in client tools for standard and enterprise.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

if you are moving millions or rows around, use a bulk method: BCP/Bulk Insert/SqlBulkCopy/SSIS. don't mess around with table variables.

Matt Miller (4/7/2008)

---

I do however think that the "32 flavors of Vista" was a disaster, especially with what I see as a lack of clear direction as to what does...