Board index MS SQL Server

Allow/Not Allow Duplicates?

Allow/Not Allow Duplicates?

Post by rb.. » Tue, 07 Dec 1999 04:00:00



Hey all you gurus out there!  This is probably something easy, but I am
having a mind block!

We have a SQL database (6.5) hosted on a remote server that we access
with SQL tools for Access 97.  When the tables were set up, one of our
fields, "email", was set as a indexed field with NO duplicates.  Is
there any way to turn this off and NOT index it (as to allow
duplicates)?  On the other side, is there any way to take one that is
NOT indexed now and index it for NO duplicates?

We try to do this, and we change the setting, but it just goes back to
its old one 1 second after we change it automatically.  It has me
baffeled.  Please give me all scenarios that you can think of.

Please respond back via posting, so all may see your answer.

--
Thanks,

Ryan Born
Gundersen Lutheran Information Systems

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 
Top

Allow/Not Allow Duplicates?

Post by Ryan Bor » Tue, 07 Dec 1999 04:00:00


Fixed, thanks anyway!

> Organization: Deja.com - Before you buy.
> Newsgroups: microsoft.public.sqlserver.server
> Date: Mon, 06 Dec 1999 17:31:36 GMT
> Subject: Allow/Not Allow Duplicates?

> Hey all you gurus out there!  This is probably something easy, but I am
> having a mind block!

> We have a SQL database (6.5) hosted on a remote server that we access
> with SQL tools for Access 97.  When the tables were set up, one of our
> fields, "email", was set as a indexed field with NO duplicates.  Is
> there any way to turn this off and NOT index it (as to allow
> duplicates)?  On the other side, is there any way to take one that is
> NOT indexed now and index it for NO duplicates?

> We try to do this, and we change the setting, but it just goes back to
> its old one 1 second after we change it automatically.  It has me
> baffeled.  Please give me all scenarios that you can think of.

> Please respond back via posting, so all may see your answer.

> --
> Thanks,

> Ryan Born
> Gundersen Lutheran Information Systems

> Sent via Deja.com http://www.deja.com/
> Before you buy.


 
 
 
Top

1. Microsoft SQL isapi extension - 405 Method Not Allowed - POST queries are not allowed - OpenXML

I have IIS installed on a Win2000 Server and i have another IIS instalation
on my Window XP laptop.

Posting a form (<FORM>) to an XML file works fine on XP but does not work
fine on Win2000.

On Win2000 I have the following error :

-------------------------------------------------
ERROR: 405 Method Not Allowed
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: POST queries are not allowed.
-------------------------------------------------

Here is the sample that i tried on my 2 distinct IIS Instalation

http://msdn.microsoft.com/library/en-us/xmlsql/ac_openxml_1pv0.asp

All this is working perfectly on XP and does not work on 2K.

please note the use of the following code

<form name="Employee"
      action="http://localhost/nwind/Template/UpdateEmployee.XML"
      method="POST">

2. Querying in-memory tables

3. nulls not allowed to nulls allowed

4. ODBC Call to SQL Server Fails from ASP Application

5. transactions: what is allowed / not allowed

6. A very strange/perplexing problem....

7. Duplicate values not allowed

8. Dotyczy: Dlugoterminowej wspólpracy

9. Not allowing duplicate entries for a given field

10. subset_filterclause in sp_addmergearticle allows 2000 chars vs sysmergearticles allows 1000 chars

11. rdConcurReadOnly not allowed if not a single select statement

12. SQL Server 7.0 allowing duplicate unique indexes

13. DTS into table won't allow duplicates


All times are UTC
Board index