To reproduce the problem, run the following script in AdventureWorks.
CREATE UNIQUE NONCLUSTERED INDEX [IX_ProductReview_Test] ON
[Production].[ProductReview] ([ProductID] ASC, [ReviewerName] ASC) INCLUDE (
[ProductReviewID]) WITH (PAD_INDEX  = OFF, SORT_IN_TEMPDB = OFF,

I am trying to create a SQL server performance dashboard for a 50 SQl Server
DBs boxes with one or two DBs in each box. For instance, on my winform or asp
page I would have a dropdownlist of all servers in my environment; once a
server is selected i will open an instance of the ...

I run a reindex of a 130GB dabase on SQL 2000 and it takes almost exactly 4
hours. IF I run exactly the same command on a 2005 box against a restore of
exactly the same database, it takes almost exactly 8 hours.
am I missing someting here? does a re-ind on 2005 work differently ...

SQL Server 2000/2005 Ent Mgr will allow you to jump into table designer and
change a column type.  2005 will capture the script, which involves renaming
the table, generating a new schema and then re-inserting the values.
 I have to perform this on some remote instances and won't ...

In SQL Server 2005, is it possible for the SQL Server profiler to miss
events?  This was the case in SQL Server 2000 in a heavily used environment.
The fix was to do a server side trace.  Does the same problem exist in SQL
Server 2005?

I have started using the Templates Window and creating some new templates.  
These templates appear to be stored at the following :
C:\Documents and Settings\<username>\Application Data\Microsoft\Microsoft
SQL Server\90\Tools\Shell\Templates\Sql\*

This seems to be a recent development.
It appears that Integer data types are formatted with comma/1000's separators.  I don't think this was occurring before.
Is this just a simple setting in QA or EM on my workstation or is this a setting on the server that may have inadvertently ...

I have a question about restoring a database using the GUI. If we log in as
the db_owner using an SQL account, click on databases and then restore we
get the message:
"RESTORE cannot process database 'XXX' because it is in use by this session.

I have my colors setup a certain way and it's very keen for me to do so. I
have been asked to share my color schema with others but don't know how. Is
there a hive/key in the registry that sets the colors? Then I could export
this and share the .reg file.

When I save my results of a query in SQL Server 2k5 Management Studio, I can
save it as a csv file.  I have found where I can change the delimiter, but I
can't find a place to put in a text qualifier.  For example, I want the text
to appear with Double-Quotes around it.

Right now, when users connect to SSMS or Enterprise Manager, they can
see every database in the server. I'd like to have them see only those
databases which they have access to. At first, I thought I could use
filters as in database object with SMSS, but it seems like that ...

In Enterprise Manager it was possible to choose different options, such as
whether to include indexes, triggers, etc., but I can't find where I can do
this in Management Studio. I can generate a script with the CREATE TABLE
commands, including the PKs and FKs, but no indexes. How ...

Can profiler be setup to capture the clients MAC Address?  If so how?

Hello.  Sorry if this isn't the appropriate place to ask this question but I
was wondering if anyone could help shed some light on an error message that
I've noticed popped up a couple of times in running SQL Profiler:
SQL Server Profiler

Hi, where can I find last change date for a stored procedure, in management
studio it shows create-date but not when it last changed.
Good to have when there are lots of developers on a test server...
Thanx