We are very interested in hearing from our users what are the top 10 issues
currently present in the SQL Server 2005 "Copy Database Wizard" that you
would like to see fixed/implemented (i.e. current problems and/or missing
functionality).

when i try to deploy a Analysis Services Database with
Microsoft.analysisServices.Deploment.exe and the Opetion "/s" i always
get the error:
The 'Name' property cannot contain any of the following characters: . ,

What are the requirements to use Management Studio/Management Studio Express
for local instances?  Are the requirements same for both studios and same for
all OS?
Based on my own testings:

Is it possble to configure Query Analyser so that the precision to be
displayed by float and decimal values can be set as a default?
For example, when querying a 3rd Party Database that incorporates
XY-coordinates as float datatypes, Query Analyser displays the precision to

  I'm a newbie to SQL so I hope I don't sound too bad here.
I have just configured SQL Mail to automatically send e-mail confirmations
to our clients when orders are placed. I have been searching the web to try
and see how to set the E-mail Template and to automatically send ...

If I specify a delete of a record in a table, using SQL under Enterprise
Manager or SQL Query Analyzer, based on the string value of a field, and
two records differ only in case regarding that string value, both
records get deleted. Evidently Sql Server is case insensitive in ...

I have an encrypted 2005 database on my development server that I want to
move to a testing server.
Both of the servers were set up using the same CREATE MASTER KEY ENCRYPTION
Yet, when I use a backup and restore to move the database, I get a

I have SQL Server 2000; a database with three file groups located in three
different operating system files; the database size is 200GB; for
performance reasons we added an additional storage to the server and we have
an additional disk volume, what we want to do is to add a new ...

How to config SSMS05 to remember the "save path" ?
So, if I'm scripting a bunch of sprocs and/or jobs, I'd like SSMS to
remember the folder I last saved to and open the browse window accordingly.

I create a new backup device that works every x time and I want to modify
this backup and I can't find it anywhere using the Enterprise Manager
I also don't really understand what is the difference between backup device
and backup a database (to a file) I assume that in both cases ...

In SQL2000 SQL Mail, I can choose the Operator as a group of operator from
Outlook addressbook.  In SQL2005 Database mail, I can add 1 address to a
operator for notification.  Any method send notification to a group of
operator?  Thanks in advance

Are there any open source/freeware tools that will script a database and its
data? I have to move a simple database from SQLS 2005 to SQLS 2000.
-- I'm familiar with RedGate, but I don't do this often enough to justify
the cost.

When I want to filter members of a Dimension in Analysis Services in
Management Studio, whith the Property UniqueName and the operator Contains, I
ceceive the following error message:
Query(1, 83) The '[INSTR]' function does not exist

Hello, we've upgraded to SS2005, and I'm attempting to install the 2005
version of Query Analyzer (Management Studio?)  on my client PC.. The owner
of the computer before me had installed many beta versions of .NEt 2.0, SS
2005.. and of course these must be removed before ...

Is there any place I can get more documentation on the the sqldiag tool that
is bundled with sql2k5?
It  looks like it is versy similar to the pssdiag tool. Is the documenation
for pssdiag also applicable for sqldiag as well?