Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-22 : 08:32:17
|
| Marcos writes "This is my problem I have three servers one with SQL7.0 and NT4.0 the other two are MSSQL2000 and Win2000 Standard serverI first created a script of one of database on SQL7.0 on the NT 4.0 boxthen i went to the other two servers that have MSSQL2000 and Windows2000Standard server and created on each the a dtabase with the same name as the one in NT4.0 Then on the 2 boxes that have Windows2000Standard server after creating the databse I ran the script that I created from the Nt4.0 box and all my table where their but they where empty so I did another step on both boxes I did and import of data but at the end i choose COPY OBJECT AND DATA BETWEEN SQL SERVER DATABASE I picked this choice because the other options where converting some view I had to table and i didnt want thatNow I was dealing with just the two Windows2000Standard server with the MSSQL2000 on one server I am able to update and create username on the loginuser table with no problem and when I go to the website I have I log in with no problemBut on the other server I can do all of the above but when I go to the website I can not log in with any username that i in anyway edit or update as long as i dont edit a name I am able to log in but the moment I touch any name or update any name all of the sudden that name is now useless I also can not create new user on the server why is this happening in one and not the otherthey have the identical software and files" |
|
|
|
|
|
Sql server2000 update on tables issue