update problem - Database Discussion Boards

Colin Angus Mackay30-Jan-06 6:52

30-Jan-06 6:52

Two ways I can think of.

1. Detach the database move the files and then attach at the other end. (You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)

2. Create a backup of the database, move the backup file to the new system, then restore the backup (you'll again have to wire up the logins to accounts for the same reasons given above).

Personally, I'd go with the second option. I've had problems with the first option when it is being attached again and SQL Server declaring it as "suspicious". The second is also easier as the backup will place everything in one (very large) file, while the detach/attach will require you to move all the files.

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Re: Moving a SQL database

shaz jazz1-Jul-06 2:17

shaz jazz

1-Jul-06 2:17

Colin Angus Mackay wrote:
(You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)
what does it mean?? i mean how can this b done??

May God help u solv ur problems as well,thx in advance!!

Re: Moving a SQL database

Colin Angus Mackay1-Jul-06 2:37

Colin Angus Mackay

1-Jul-06 2:37

shaz jazz wrote:
(You'll then have to wire up the logins again as the login ids will be different because they are stored in the master db)
what does it mean?? i mean how can this b done??

It means that logging into a SQL Server is performed at the server level, not the database level. Each database just contains the details of which logins are permitted to access it (but not how to authenticate those logins). If you move a database to a new server the mapping between the logins in the master database and the users permitted to use a specific database may be incorrect.

When users are mismatched from their logins you can use sp_change_users_login[^] to fix the mapping.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Recursive Data

Bassam Saoud30-Jan-06 5:06

Bassam Saoud

30-Jan-06 5:06

Hi ALL,

I have a table where data is stored in a Hierarchical manner. For example
User1 supervise User2 and User3
User 2 supervises User3 and User4...
How can I loop through the hierarchy get all users supervised by user1 dynamically? That is in the example above (User1, 2, 3 and 4)?

Re: Recursive Data

Damodar Periwal3-Feb-06 14:01

Damodar Periwal

3-Feb-06 14:01

Is User3 supervised by multiple people (User1 and User2) or that is just a typo?

Damodar Periwal
Software Tree, Inc.
Simplify Data Integration
http://www.softwaretree.com

How to get SqlTypes of a particular column in sqlserver using C#

YogeshChoudhary30-Jan-06 0:59

YogeshChoudhary

30-Jan-06 0:59

I am using Datatable. I can get DataType but could not get SqlType.

-- modified at 7:20 Monday 30th January, 2006

How to generate a sql db from a xml file

User 231751430-Jan-06 0:58

User 2317514

30-Jan-06 0:58

I need to generate a sql 2000 db from a xml file how do a do this. I use sql 2000 and vb.net on vs2003

modified 2-Feb-21 21:01pm.

update problem

kings_128-Jan-06 15:57

kings_1

28-Jan-06 15:57

hi there ,

in my program i have the Order Form (win Form)
in this form i have some textbox and grid

know the grid is bound the a dataset on the grid i have some filds like productID,Qunataty,UnitPrice,Total

i am filling all the data on the Form and the order is insert well to the db

now if i want to change something in this particular order i select the order detiles from the db by OrderId num
an all the order detiles are displayd on the Form

the problem is when i want to add products to the order
the product detiles that is bound to the datagrid is updated but the OrderId is not

this is the code :

<br />
if(dsOrdersDetiles1.HasChanges()==true)<br />
               {<br />
<br />
<br />
                    AdOrdersDetiles.Update(dsOrdersDetiles1.Tables[0]); //only the data in the grid is update but i  need the OrderId to be update in the same row .<br />
               <br />
                    <br />
               }<br />

how can i update order detiles when the filds are not bound ?

-- modified at 21:59 Saturday 28th January, 2006

Certain Numbr of records

gharry28-Jan-06 3:36

gharry

28-Jan-06 3:36

Is it possible to read the first 20 records from a table in one SQL statement

Re: Certain Numbr of records

Colin Angus Mackay28-Jan-06 6:01

Colin Angus Mackay

28-Jan-06 6:01

Use the TOP keyword right after the SELECT

SELECT TOP 20 * FROM MyTable

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Autonumber in MS Access

alfakappasigma27-Jan-06 23:49

alfakappasigma

27-Jan-06 23:49

Hi everybody, I'm using ASP.NET VB / C# application with MS Access. After successful insertion from my register.aspx page into Customers table, the CustomerID field (autonumber field) gets a randomly generated number which I'm using as the primary key. But sometimes, it generates a negative integer which is not appropriate for using as customer ID. Can anyone suggest me how to get only a postive integer. Also, it doesn't always generate a fixed-length integer. I want to be able to generate a customer ID with a fixed length. Please do suggest me a solution on these issues.

Is there an alternative way to generate this non-negative, fixed-length, unique customer ID through .aspx page itself? Could you help me with code please! Thank you.

Anjani Shiwakoti

Computer programs and social cultures are the same.

Re: Autonumber in MS Access

Pankaj Kulkarni30-Jan-06 0:47

Pankaj Kulkarni

30-Jan-06 0:47

Hi,

If you don't want Randomly Generated Number then
The primary key i.e. CustomerID Datatype should be Long Integer/Double. Having "Increment" property set to 'Yes' with Increment Seed '1'.

Pankaj Kulkarni

-- modified at 0:50 Tuesday 31st January, 2006

Re: Autonumber in MS Access

alfakappasigma31-Jan-06 6:43

alfakappasigma

31-Jan-06 6:43

Hi Pankaj,
While I do appreciate your suggesting using increment property instead of random, I've tried that before but I decided to use random number as customer ID because those random numbers are hard to guess and they can be used to retrieve customer's password in case he/she forgets one. My only problem is sometimes the autonumber creates negative integers, and also the numbers aren't always of a fixed length. If you (or anyone else reading this) could suggest me a better solution, I'd greatly appreciate it. Thanks.

Anjani Shiwakoti

Computer programs and social cultures are the same.

Re: Autonumber in MS Access

Luis Alonso Ramos31-Jan-06 7:58

Luis Alonso Ramos

31-Jan-06 7:58

And what happens if suddenly you get a random number that already exists?

Use an autonumber column and keep the ID private to the application. And to let the user retrieve his password, ask him for an email address during signup and send it to that email address.

-- LuisR

Luis Alonso Ramos
Intelectix - Chihuahua, Mexico

Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

Re: Autonumber in MS Access

alfakappasigma2-Feb-06 7:38

alfakappasigma

2-Feb-06 7:38

Hi Luis,

While I do appreciate your suggestion, I've decided to seed a random postive integer with a fixed length right from my .aspx page, instead of letting MS Access create it for me. I guess that takes care of it. BTW, I don't think that random autnumber will 'suddenly' create a number that already exists in the database. It guarantees that every number it creates will be unique.

Anjani

Computer programs and social cultures are the same.

Get Highest Value....

Sasmi27-Jan-06 2:55

Sasmi

27-Jan-06 2:55

Hi Guy's
i have problem in finding highest value from two column
eg.
i have table 'MyTable' with Column 'ID','Column1','Column2'
which contained data as
ID Column1 Column2
01 100 102
02 50 60

I want to find out the highest value of 'ID' 02 of this two column (i.e. 60) in SQL Query

Sasmi

Re: Get Highest Value....

Colin Angus Mackay27-Jan-06 2:59

Colin Angus Mackay

27-Jan-06 2:59

SELECT MAX(ID) FROM MyTable

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Re: Get Highest Value....

Sasmi27-Jan-06 3:14

Sasmi

27-Jan-06 3:14

i dont want the maximum value from the ID column
i want to find out the highest value for a perticuler row in different columns i.e. if i have table with two columns Column1 and column2
Column1 has three rows with values 100, 45, 50
Column2 has three rows with values 101, 25, 40
now i want to find the higest value in first row of Column1 and Column2 which is 101 similarly for second row highest value is 45 and theird row highest value is 50.
so how do i go about doing this

Sasmi

Re: Get Highest Value....

Colin Angus Mackay27-Jan-06 3:25

Colin Angus Mackay

27-Jan-06 3:25

SELECT ID, CASE WHEN Column1 > Column2 THEN Column1 ELSE Column2 END as Highest
FROM MyTable

Selecting records from the table

sasire1826-Jan-06 19:31

sasire18

26-Jan-06 19:31

hi I like to select certain number of records in the range format from 100 to 200 from the table with condition and displayed in the query analyzer .Which is the best way to achieve it .Earlier I was using Top 200 * from tablename1 where condtion but it is not helping me to get the desired result .

Any other format to retrieve records from the table .A single table is having thousand of records.Using select column names with condition also proved fatal numerous of records are coming

any good query for this

sasi

Re: Selecting records from the table

sathish s30-Jan-06 0:58

sathish s

30-Jan-06 0:58

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2005-32,GGLD:en&q=sql+server+paging

Using MSDE

TheJudeDude26-Jan-06 13:33

TheJudeDude

26-Jan-06 13:33

I am trying to expand my knowledge of SQL and I am using the MSDE. I am trying to add/import the Northwind database to this server, but I am lost on what to do?? Could someone give me some help?
thanx in advance,
Jude

Re: Using MSDE

Paul Conrad26-Jan-06 18:46

Paul Conrad

26-Jan-06 18:46

Any particular reason for MSDE? SQL 2005 Express is good and SQL Server Management Studio Express CTP makes administering it easy.

Paul

Re: Using MSDE

TheJudeDude27-Jan-06 2:31

TheJudeDude

27-Jan-06 2:31

from what I know 20005 isn't comaptible w/ VS.net 2003

Re: Using MSDE

Paul Conrad27-Jan-06 3:45

Paul Conrad

27-Jan-06 3:45

This is what I did with MSDE. I use a program called DbaMgr V0.55.1 (a free wanna-be Enterprise Manager). I don't remember the link to the program, but I am sure it's one of the first hits one can find get on google. You can use DbaMgr to setup the Northwind database.

I hope this helps,

Paul

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.