Re: Table loseing primary key when not local admin?

Tech-Archive recommends: Fix windows errors by optimizing your registry



well basicly its create a blank dataset.. create a data adapter with
Sel/Upd/Del/Insert stored procedures... fill the dataset's table with fill
schema then fill with data then try to find an item in the table by key
using the find procedure... I kind of think its database side also too
though yes we are usign windows authentication, and we did notice that when
we add them as local admins to sql server 2000's server it suddenly works...
remove them from that group, it doesnt work.. any idea on how to fix this?
thanks because they have access to the database to start with and have all
the permissions on the stored procedures that they use to interact with the
database through a Role permission set.


.



Relevant Pages

  • Re: "Could not determine which columns uniquely identify the rows for tablename"
    ... > I am in the process of migrating our MS Access Database to Informix ... > ready yet), but I have tried the below on the Linux Server, SQL Server ... > Data Adapter Configuration Error... ...
    (microsoft.public.vb.database.ado)
  • data set fill causes app hang
    ... back to the sql server 2000 database server it causes a application hang ... way i can turn this update from the data adapter into a background process ... some show of progress on screen.. ...
    (microsoft.public.dotnet.framework.adonet)
  • AllowDBNull in DataTables
    ... I use a data adapter to fill a DataTable ... with data from a table in my SQL Server Express database. ... the table in the SSE Database has columns where NULLs are not allowed. ... myself after the Fillmethod is called, setting AllowDBNull = True seems ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Strange problem. Need help!
    ... SQL Server or MSDE, use SqlClient, keep all the table structures and queries ... against the database in hopes that holds a clue. ... I read the table into a DataSet with the data adapter in step 2. ... I am using a where clause on the command object to only get the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Datagridview vb.Net (Update Insert delete)
    ... you use a data adapter to fill a data table. ... After you update in the datagridview, ... use the data adapter to save the changes to the database. ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)