I apologize ahead of time for the long post...
Background:
Working on a CRM type custom application. The application is for an
event management company. The company will provide the application for

I have a table that contains articles (as in, newspaper articles, blog
articles, whatever).  I need to use a column of type uniqueidentifier
because one of the requirements is that I be able to write the articles
out to XML or import them from XML, and references (as in, "for more

I have set the DB to auto grow  by 30 %. As well I have set it to
unrestricted size.... However , I see the available size continually being
reduced to now less then    .54 MB... Why is there not enough available ?
G

I know the max row size in SQL Server is 8060, but what happens if I go over
the max row size.  Will some of the data be lost?  Will I have problems with
backing up the database or importing or exporting data?  Also, does the 8060
size apply to rows in Views also, or is it just ...

Let's say i have a database with the following structure and data
tablename: customers
customerID| customername | PictureID|
1         | MyCustomer   | 1.jpg    |

Is there any advantage to doing this:
ALTER TABLE testtable ADD
    CONSTRAINT PK_sysUser
        PRIMARY KEY  NONCLUSTERED (UserID)

I'm new to SQL server. I have a question btw MS SQL server and Microsoft SQL
Server2000 Desktop Engine.
What is different  btw MS SQL server and Microsoft SQL Server2000 Desktop
Engine ?

I have inherited a custom build application that is being nominated to
get replaced by something else (which is not known for know).
The company who created the application is gone and while the
application was reasonable good it won't run with XP SP2.

I have tried to install SQL Server 2005 CTP version on my machine WinXP Pro
-1GB RAM but it gave me the following  error.
/**********************************
The SQL Server System Configuration Checker cannot be executed due to WMI

I am having trouble finding my SQL server from a remote SQL server running
2000.
Please help.

Can someone pls let me know the location from where i can download SQL 2005
latest beta release.
Regards,
bobby

I buy a programing book with source code.But the database only can use
English to input data.When I input Chinese,I read "??" from the database
table.
I need help,Thank you!

Having trouble with this assignment. My teachers say it should work but it
just doesn't. This part of a macro is designed to take payment from the cost
and show the balance owing. What am I doing wrong. The sql is shown below.
No error message is showing but the process still ...

Dear Group
Can anyone provide a sample query for the following scenario?
Let's assume I want to search for an order someone placed which might
be an individual or company. An individuals first name is stored in

Hi Group
It's a rainy day and because of pure boredom have right-clicked a row
in EM and selected 'Properties'.
Just being curious what the dialog coming up is all about (call me