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 |
|
ce-it
Starting Member
3 Posts |
 Posted - 2007-07-16 : 08:31:21
|
Hello Everyone,I really could use some help on this SQL2000 issue, so I would like to thank you up front for any assitance.The network is a Windows 2000 platform, the old server(win2k)has pretty much crashed and burned, I have the old server running just to export the db to the new server.The new server is still win2k, the os is stable. Now here's the problem, I've imported the db (just 1 db, aka c21)into the new enviorment including the db users/logins. Now from the application I can connect to the SQL, execute quries, view records, edit records, and delete records; sounds like everything should work. When I add a new record, then try to view it from the application, I can't, but when I goto the SQL console and execute my select statement I can see the record, just needed to verify if the record was indeed writen to db. This problem has me confused. Could someone help resolve this issue?  Thanks AgainD |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-07-16 : 08:36:03
|
| Sounds like the application is connecting to the old server for the reads.Use the profiler to check te sql being executed.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ce-it
Starting Member
3 Posts |
Posted - 2007-07-16 : 09:14:30
|
| The app connects to the sql db with an ODBC connector, the ODBC is pointed at the new server, the conn also tests out fine. |
|
|
|
ce-it
Starting Member
3 Posts |
Posted - 2007-07-16 : 09:50:41
|
| What is profiler and how do I use it? I know enough about sql to be dangerous, but by no means an expert. ThanksD |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-16 : 22:44:01
|
| Search profiler in books online, you'll find details. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-07-17 : 07:54:47
|
| You'll find it under tools in enterprise manager.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
sql2000 DB Transfer