|
I have the next problem: in the table with the primary key field "ID" (it is identity with automatic incrementation) when I delete row, the row isn't completely removed - the ID field remain (although it looks like row was removed) - and as a result, next created row has ID wich is equal to ID of previous deleted row + 1. How to delete row from table with autoincrement primary key correctly?
...fear makes people manageable...
|
|
|
|
|
When you have an identity column you do not get deleted id's back. If you delete all rows from the table and want to reset the identity back to a value you need to do this:
DBCC CHECKIDENT('TableName', RESEED, 1)
Hope that helps.
Ben
|
|
|
|
|
|
Noob question:
If I have several (4-5) computers with SQL Server 2005 Express on them, can they all access the same database file located on a remote/network drive? Would they be able to access it at the same time?
Brad
The secret to creativity is knowing how to hide your sources. - Albert Einstein
|
|
|
|
|
No.
SQL Server opens the file exclusively and controls it completely. Only one instance of SQL Server can open a database file. Also, the files must be on the same physical machine as the SQL Server.
However, you can link SQL Servers together so they can share the data. The SQL Server that owns the file will control all access to the data.
|
|
|
|
|
Hey everyone,
I am working on this project, mostly database driven.
this is what it is about:- The user interface is install on three computer in different location while the database is kept on another computer in a seperate location, which means all three computers has to connected to this sql server to enter and retrive data. That means if the server goes down.. neither of these location will be able to continue there work.
What i am thinking about now, is to install sql server on all three machine so that data is stored at each location and at the end of each day all the data from the three location would be uploaded or Synchronized to the main database.
Problem.. how do i get all three database to Synchronize with the main database? Do i have to hard code this to happen or is there a feature that does this in sql 2000...
your help would be highly appreciated...
thanks.
Nab
|
|
|
|
|
|
Hi, I am trying to generate a typed dataset with an xsd schema, but I seem to do it only half right.
In one application, I read my MySql database (4 data tables) into a simple dataset, I define the relations and I export it with the WriteXmlSchema method. This works fine.
Then, I import my newly created xsd file to another project, in which I want to create a typed dataSet. In this project, I'm able to view my schema, and when I right-click and select Preview DataSet, everything looks great, I have my 4 tables and all the Properties are shown.
However, when I select Generate DataSet and go write some code, I only have one table for which a FindBy method has been generated. No property is defined in my other 3 tables.
Can somebody please help me, this is driving me nuts!
Thanks!
-- modified at 10:27 Wednesday 14th March, 2007
|
|
|
|
|
Hi,
I am doing a project that involves Ms Access database connectivity in vb.net.I can do the insertion and updation of record by the code as mentioned below:
Imports System.Data.OleDb
Public Class Form2 Inherits System.Windows.Forms.Form
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Dim icount As Integer
Dim str As String
Private Sub Add_Click(ByVal sender As System.Object, ByVal e As_
System.EventArgs) Handles Button2.Click
Try
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\emp.mdb;")
cn.Open()
str = "insert into table1 values(" & CInt(TextBox1.Text) & ",'" & TextBox2.Text & "','" &_
TextBox3.Text & "')"
'string stores the command and CInt is used to convert number to string
cmd = New OleDbCommand(str, cn)
icount = cmd.ExecuteNonQuery
MessageBox.Show(icount)
'displays number of records inserted
Catch
End Try
cn.Close()
End Sub
End Class
Updation of records
Me.BindingContext(ds, "Employee").EndCurrentEdit()
Me.da.Update(ds)
But I cannot do the saving and deletion of record.I would be very thankful if anybody can help me out in this difficulty.If possible plz provide me the code.
Thanking You.
Romana Sayed
|
|
|
|
|
Make sure that you have dataadapter update command specified. This might prevent updation using dataset
|
|
|
|
|
Hi ,
If u can plz provide me the code for click event of a button(ie save or delete).I am not able to delete record from an access database using OleDb provider.
|
|
|
|
|
Hi,
I'm trying to experiment with the newest version of former 'sql everywhere' and found the following problem (the way to reproduce in VS 2005, SP1):
1) in 'server explorer' I made new database (sdf file) with a couple of tables an some columns
2) new c++/cli project, trying to add new datasource project
3) select table(s) in the wizard ... everything guess goes well ...
4) on the stage of creating dataset:
Creating DataSet class using XSD ...
Writing file 'c:...DataSet.h'.
Error: There was an error processing '.\...DataSet.xsd'.
- Error generating code for DataSet ''.
- Failed to generate code. Failed to find or load the registered .Net Framework Data Provider. Failed to find or load the registered .Net Framework Data Provider. <---- ?!?!?!
Oops, dataset.h file is absolutely empty  Has anybody experienced same problems?
Dmitry
|
|
|
|
|
Hello
I have one table say table1. I want to restrict deletion and updation for this table. Any idea ? I use SQL Server 2000
|
|
|
|
|
Use REVOKE[^] or DENY[^]
e.g.
DENY UPDATE ON [TableName] TO [UserNameOrGroup]
DENY is more final. REVOKE just means don't permit it for a user with this role unless some other role they are a part of grants the permission. DENY means no access at all regardless of what other roles the user has.
|
|
|
|
|
Hello
Thanks, I tried your suggestion. It was not working. I am working on a user id called 'navaneeth'. So i tried this
DENY UPDATE ON MYtable TO navaneeth
Then i tried to update. It was updating ? Where am I wrong ?
|
|
|
|
|
DooDooo wrote: Then i tried to update. It was updating ? Where am I wrong ?
It is possible that you are trying to deny access to an object you already own. If I remember correctly, you cannot deny yourself access to your own objects.
If this:
SELECT USER
returns the same value as the TABLE_SCHEMA column in this:
SELECT * FROM INFORMATION_SCHEMA.TABLES
for the corresponding table, then that's your answer.
|
|
|
|
|
PlayByTheRules wrote: returns the same value as the TABLE_SCHEMA column in this:
SELECT * FROM INFORMATION_SCHEMA.TABLES
for the corresponding table, then that's your answer.
Yes that was the answer. Thank you very much
|
|
|
|
|
how to delete a sql database.
it contains a single table.
I have tried dropping the table first.
the table is deleted, still i get an exception saying the database is being used.
thanks in advance.
Keshav Kamat 
India
|
|
|
|
|
Close all applications that are accessin the database and then delete.
or
Stop & Start SQL Server, will close all open connections
Cannot drop a database currently in use i.e. open for reading or writing by any user
Regards
KP
|
|
|
|
|
Hi,
When u cannot delete a database that means that a connection to the database is still alive.
- If u want to delete it from SQL Server Entreprise manager, do the following :
1- Right click on the database
2- Choose All tasks \ Detach database
3- U can see the number of connections to the database. Click on the Clear button to force open connections to disconnect.
4- Do not detach the database but click on cancel and now u can delete the database.
- If u are deleting the database from SQL Query Analyzer be sure to be not connected on the database to delete. Choose the master database in the combobox. To delete the database just execute the query :
Drop database YourDatabase.
- If ure using .net to delete the database. U must turn off Pooling in your connection strings. That's because even u close all connections by using Connection.Close() method, connections still open for performance reasons.
HTH.
|
|
|
|
|
Hi,
Relational databases have been around for some time. Does any one know when a new type of database will emerge? I have read up on about object database management systems (ODBMS), object relational databases, and I have been working with an RDBMS for years now.
How does any rate the database called Matisse? Apperently it was the first of it's kind, are there any others that are good, or better?
What database does Google use?
I hope to hear many opinions!
Regards
ma se
|
|
|
|
|
ma se wrote: What database does Google use?
No idea and no way to clarify. After doing some googling I found that, they use their own special database and file system software for the main indexing of the data returned by their crawlers. But someone is telling highly modified postgreSQL and also MYSQL. Which to believe ? Google had 100 million pages in their index in 1997. And they wrote that their total DB capacity is something like 128GB !!! Amazing ? Do you have any idea about how they will store information ? Will they store all informations from webpages ?
ma se wrote: I have read up on about object database management systems (ODBMS), object relational databases
ODBMS !! Sounds great. I think it has the Ability to map data stored in a database directly to the language object representation.
ma se wrote: How does any rate the database called Matisse? Apperently it was the first of it's kind, are there any others that are good, or better?
No idea regarding Matisse ? Is it released ?
|
|
|
|
|
Yeah go and check out http://www.matisse.com/[^]. I think I found a sample on how to connect on codeproject, it looks really cool and different.
|
|
|
|
|
Hi all
I need to implement site search for my website. Which is the best way to implement one ? What is your idea on maintaining indexes ? I am using MYSQL database.
|
|
|
|
|
Hi all, I started playing with the ADO.NET, so what I did was the following, added a dataset to my solution, draged the table from the database onto the dataset via the Database explorer, then I created a new form, set the dataset to GridView in the datasource explorer and then dragged the dataset from the datasource explorer onto the form, it then created the grid and all the columns etc. Now for my problem, it loads the default values in the database table in the grid, I can then modify the values and create new values and they are all stored in the dataset, but never updates to the table, so if I close the program and opens it none of the changes made and new values are there. So how can I save the values from the dataset to the database.
Here's the code that I use to save the changes made.
private void productsBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.productsBindingSource.EndEdit();
this.productsTableAdapter.Update(this.productsDataSet.Products);
}
He who laughs last is a bit on the slow side
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
