Via sql , I created a unique constraint on my table , but in SSMS it doesn't
show up in the Constraints list but rather in the Indexes list.  I know that
Sql Server internally implements unique constraints as indexes , but why
won't it show up in the SSMS Constraints list ?  Is ...

I am migrating from one SQL-based help desk system to a competing one. I have
a few hundred tickets to migrate to the new system. What is the proper tool
for migrating data in this case, where the databases are different? For
example, I want to be able to tell the tool that ...

SQL Scripter is an easy to use data export, import, scripting and reporting
utility for Microsoft SQL Server (MSSQL).
- Generate T-SQL Data Scripts (Insert, Update, Delete)
- Quick Scripter (Script all table in a single step)

I just found out from performance dashboard that there is an active trace
running.  I have no idea when it is started. Is there a way to stop the trace?
Is the tracing part of the server background process that starts
automatically when you start the server?

at a few months ago we made a Small business install and a few days ago we
start getting a message from management studio evaluation "period has expired"
that aplications into the server are working well.. and we made a sp1
install and correction into reg like this kb article

I have installed on a  user  the  SQL Server  Management Studio Express
console and  they have full control , at  least  I think so to the  a  
specific database.  The  problem is that the  user  needs to  be able to
click on the  relationship diagram button  in the  console but  ...

I have it installed. How do I collect data and look at the report?
Thanks.
Pingx

Earlier today I was trying to install what I thought was SQL2005 Standard
64-bit but proved to be Enterprise Edition. I uninstalled but now I find I
have Standard Edition for the database engine but Enterprise Edition for the
Client Tools.

I have a problem with a production SQL box.
The problem is that once or twice a day the box is getting its processor
allocated for 100% for 10+ seconds.
How can I find out what command or something causes that?

I am getting an error in Microsoft SQL Server Management Studio when
designing a View on a Table. The table definition is:
CREATE TABLE [dbo].[Deals](
[recid] [int] IDENTITY(1,1) NOT NULL,