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 |
|
abuzar
Starting Member
20 Posts |
 Posted - 2014-01-30 : 18:36:01
|
| i am using sql server 2008 developer edition on in my desktop pc.i created a database in which there's a table that contains a column named "images" with a data type image for storing images in database.And all is working very fine No issue in this.the problem arise after i copied the .mdf and .ldf files from my desktop to my laptop which also have same sql server 2008 developer edition.Coming to the main issue "is I am not able to To save ,update images in that table from my laptop.i tried the best of what i could do but unsuccessful. i formatted my entire laptop as i thought of; that may be there's a problem with my windows or some virus issue but after all the struggle still there's the same issue driving me mad.Plz help me plzz. or else ill go mad banging my head.basically the same thing works flawless in my desktop but not in my laptop.thankz abu |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-01-30 : 19:39:34
|
| How did you migrate the database? Backup/Restore? Detatch/Attach? Can you modify othe columns in that table? can you modify other tables?===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961) |
 |
|
|
abuzar
Starting Member
20 Posts |
Posted - 2014-01-30 : 19:55:46
|
| 1st i disabled all the services from sql configuration manager then i copied the mdf ldf file from my desktop to my pendrive and then to my laptopto sql folder cdriveC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-01-31 : 13:09:18
|
| I'm surprised that SQL sees the files at all if all you've done is copy the files. Normally you need to attach the files somehow. Can you try to use either a detach/attach or backup/restore to migrate your database?===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961) |
|
|
|
|
|
|
null values are getting Updated need help