Also, you might want to join http://www.LazyDBA.com . They have a quite active dedicated Oracle mailing list oracledba@lazydba.com.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

When transferring data from SQL Server to Access this is normal behaviour. Only the raw data is exported, no indexes, no constraints...

Frank

http://www.insidesql.de

http://www.familienzirkus.de

in addition, what does your PK look like.

Access autonumber field?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

How can I transfer an access file into SQL server. I can get the information into the sql server but I have...

Do not directly update the system tables

http://support.microsoft.com:80/support/kb/articles/Q274/1/88.ASP&NoWebContent=1

http://www.sqlservercentral.com/sitesearch/cgi-bin/es/esearch.asp?start=0&perPage=10&summary=yes&sort=rank&search=orphaned+user

might help you with respect to your first problem.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Another one:

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

Edited by - Frank Kalis on 11/07/2003 08:05:01 AM

quote:

---

No nothing more than space waste.

I thought this was interesting on the KB Article thou

---

as...

Found the answer to my own question in the same chapter....

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yup, found the text in Inside SQL Server. So far for the storage engine.

And then there is the relational engine and both communicate with each other.

Btw, Antares, did you...

Doing time waiting for the weekend I found this source to the ultimate computer language

http://www.baetzler.de/humor/null.html

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Just came across this description of a VP

http://home.zylstra.com/comedy/lists/hunting-elephants.html

..somewhere down the second half of the document

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Strange, it is working for me.

This one I bet will be splitted by forum software. You'll have to manually copy and paste

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q175/2/39.ASP&NoWebContent=1&NoWebContent=1

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you post where you have found this in BOL?

I always thought that the leaf level of a clustered index contains not only the index keys, but the data pages.

Just...

Here is the article I had in mind

http://support.microsoft.com:80/support/kb/articles/Q175/2/39.ASP&NoWebContent=1

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Have you tried

http://www.sqlservercentral.com/sitesearch/cgi-bin/es/esearch.asp?start=0&perPage=10&summary=yes&sort=rank&search=data+dictionary ?

Might be a good starting point.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

The best job title I've ever seen so far, was when I dealt with a banker whose business card stated explicitely in english 'Head of Client Execution'

Frank

http://www.insidesql.de

http://www.familienzirkus.de