I don't know if this is the group for questions about the Management
Studio.  If not, please let me know where I should post.
For some reason, ever since I had an auto-update from MS, my
Management Studio (v. 9, using XP) takes an incredible amount of time

sql server express is not yet installed.
i have a few hundred documents, several typewritten pages apiece in pdf format,
i'd like to search with multiple words or phrases. during the next two years i
expect the document quantity to triple. adobe reader is not up to the task. the

Ok, basically I am in the process of trying to sort my app out with unicode
support.  A good way of doing this would be to use ADO.  However, I have been
told by the powers that be, we originally used ADO but had to remove it
because the connection back when using ADO uses a ...

The following query will return 3 word in 3 "TABLE COLUMN", How can I
modify the query to return "NO 3 words are the same"?
the following Table will have duplicated as both row has the same 3
words, I only need "a, young, woman" is enough. I do not need "a,

I recently moved our database from SQL 7 to SQL 2005. I configured the
maintenance plan in SQL 2005 and ran it. However, the server hung when the
plan was run, and had to be rebooted. I'm trying to determine what went
wrong.

the collation of my database was: "Latin1_General_CI_AI".
I changed it for "Chinese_PRC_90_BIN" because I want to store chinese
and english stuff.
I used this SQL command:

I need to do some testing on an app. I restored the sql 05 database on
a new server. Here are the following steps I did:
1. restored db
2. edited the schema to point to dbo

Hi guys... im just trying to update a table using 2 server (using
Linking Server)
this is the scenario just like i`ve done..
update db1.tl_autos.dbo.au_automoviles set au.agente_callcenter =

I have just installed SQL 2005, SP1 server on two test computers and am
trying to get database mirroring to work. No witness server is being
used. I have done a FULL backup of the database and backed up the
transaction log.  I have also restored the database and the transaction

I have a table T1 with fields ID,  F1, F2, F3, F4, F5,SL_NO and so on. The
ID column is an identity column and Primary key.
Now the SL_NO needs to be reset to 1 when the combination of F1 + F2
changes. It needs to keep incrementing as long as F1+F2 remains same.

Can anyone tell me if there is a keyboard shortcut to switch between query
windows in SQL Server express (whenjh I have multiple queries/views/tables
open in the main window).
Many thanks,

The following query will output 2 words that's close in position, but
how can I output 3 word that's close in position instead of 2 word?
the query will have 3 column output instead of 2 column output for
words.

I recently converted all my db's bit fields to smallints. I refreshed all
the views using:
SELECT 'EXEC sp_refreshview ' + quotename(name)
FROM sysobjects

I have the following questions:
1. How many SQL server 2008 and Express can be installed per domain? can you
refer me to any MS documentation regarding this. I found  a limitation for
number of instance per server.

I have another sort of flattening problem, but more of a tree issue I think.
create table attributes
(
parent_id int,