I  have a small client who wants to consolidate Terminal Services and SQL
Server on the same box to save money. I have never been a proponent of this
but I also can't find a Microsoft best practice that addresses this.
Has anybody seen a Microsoft blessed best practice on this? Do ...

I'm running SQL Server 2005 Standard x64. All datetime columns show up in
Management Studio with precision only to the second. The thousandth portion
is suppressed. I can enter a value such as 2007-08-30 12:34:56.789, but as
soon as I leave the row, it reverts to 2007-08-30 12:34 ...

Please any body has tried to install SQL 2000 on Windows Server 2003 R2
Very urgrnt to know ..
thank you

I've a folder called C:\a121651d93e50df9b4b1 and under this looks to be 26MB
of SQL hotfix data.
Normally, I find SQL patch data under the %SystemRoot%, but whatever.
Anyway I like to delete these after a while, but this time I can not.

I have a development environment where I have SQL Server 2000 installed.  It
was installed with the wrong collation order and it appears the best way to
correct this is to re-install it on the server.  When I try to uninstall it,
however, I am getting this message:

Hi all...
I have read that SQL Server 2005 Standard can use up to 4 CPUs.
The server in question has 4 Xeon dual core processors (or at least they
show up as 8 in Task Manager).

I am accessing data in a remotely located mssql database.
When I access locally, I can retrieve 166+ records (in this particular table
in this particular database) in under a second.
When I access to the same set of data in the office (using a vpn connection)

Ok, I've got a SQL cluster where the nodes:
Windows 2003 R2 Enterprise (32 bit)
SQL 2005 Enterprise
Quad processors

I am having issues with a 2 node SQL Server 2005 failover installation.
Both nodes are operational, everything in Windows Clustering appears to be
fine, the SQL System Checker recognizes both nodes, however, when I do the
installation for SQL, I get Node2- Unavailable, therefore, ...

Hello, I want to know if there is a way to specify the sa password, and
other setup preferences in a setup file in sql server express 2005, like the
.ini files in MSDE 2000.
Thank you!

We have an application that is only supported SQL 7.0. I am in the
process of replacing the current server with a new one. The current
server runs SQL 7.0 Standard and I would like to take advantage of the
additional memory on the new server so I am going to move to SQL 7.0

Can anyone help me to get the hotfix SQL Server 2000 build 8.00.2215 ?
As i do not find any download link.

We just migrated a large database from SQL 2000 ent ed. to SQL 2005 ent. ed.
This migration included moving to larger, faster hardware on an
active-passive clustered pair of Win 2003 servers (32 GB RAM, quad
processors, etc). Setup went fine.

I need to link to an Access db that is a frontend to a SQL Server. I have the
DSN. An MVP told me that if I link to this db in an .adp file I can view the
relationships?  All I have is the .mde without the relationships.  Do I need
Enterprise manager from SQL Server 2000 or will ...

Are there any solid documentation for installing visual studio and sql
server 2005 on a same machine, so I can avoid any potential installation
glitches?
I searched MSDN and other online references, I couldn't find anything i