We have done about a dozen installs of SQL2005 in labs and in production and
found that the tools work only if every component is installed on C:.  On
several production servers, we need to have the database on a large drive
other than C:, but when the "data" portion is installed ...

does anyone know a tool to convert a SQLServer2005 database to
SQLServer2k?
--
candide_sh

I caught all RPC:Completed, SP:StmtCompleted, and SQL:BatchCompleted events
that occured in the system (based on prepared statements, so that's why I
included statement level of events) during one day, and I ran DTA against
this trace file.

When I use the generate scripts task in Management Studio to create tables
for a SQL 2000 target, the scripts do not run in SQL 2000.
I selected SQL 2000 compatibility mode.  The scripts work fine on a 2000 database
running under SQL 2005 but not on the real thing.

using 2005 management studio i made changes to an 8 step job on SQL 2000
server. I inserted a new step into position 8  and then tried to save it.
SQL2005 management told me that some feature was not supported on SQL 2000
so i pressed cancel. at this point both SQL 2005 management ...

Don't know if this is the best place to post this but I have a db with about
100 tables and a number of views and sprocs. When scripting the entire db
using SMS, a number of the views and sprocs are created before their
associated underlying tables are. Can anyone shine a bit of ...

We have developed an application that use .NET 2.0 and in the same
server are installed the SQL server. The problem is that when i use
"LOCALHOST" on the application everething works fine, but when i chage
it to the IP number the application works VERY SLOOOW.

Can someone tell me where to turn in bugs for SQL server?
I'm using the MS SQL Server Management Studio and when I change my table to
custom view and print them, they are printing funny.  I can send the
printout to someone if needed.

My server is running with 2003R2 x64 with SQL 2005. Some of my client
computers are having some issues with ODBC errors while working in an
accounting package. I have been told that it is most likely a driver
compatibility issue between the XP pro versions on the clients and the ...

I have SQL 2005 64bit edition and I can't get the SQL tools ie SQL
Server Management Studio installed on my 32bit XP workstation.  All of
the setups say not a valid 32 bit application or they say they don't
run on my processor.  (Pent D 2.8)

blah

I'm planning on moving a database from one SQL Server 2000 server to
another [also SQL Server 2000].  The application that relies on this
database has a Microsoft Access front-end and relies on some Data
Transformation Services components on the database server.  I don't

SELECT name
FROM sys.server_principals
WHERE name = $(dbuser2)

I am suprised - Googling found nothing. Does anyone have any sample scripts
they can share? Or have pointers to any?
Thanks
Chris Harrington

Has anybody else ran in to the following problem?  If so, have you been
able to correct it?
When you right click on on the Views folder and select new view, the
add table window takes 2 to 4 minutes to appear.