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 |
|
trixdhy
Starting Member
2 Posts |
 Posted - 2012-04-18 : 05:46:02
|
| Dear All, I Have problem when inserting data to table in another server (Server1), I use query "Insert Into TableName (Field-1 - Field-N) Values ( Data should be inserted)", but in another case the same query like above is Successfully execute in another server (Server2).I Already try to create table in (Server1) as same as structure in (Server2), but I have the same error again in (Server1).if there's anyone already have experience with this error, please help me to solve the problem.Thanks Before |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-18 : 07:08:00
|
| It may be that the servers are not linked correctly or it may be permissions issue, or something else. What is the error message you are seeing? Hard to speculate the reason without seeing that. |
 |
|
|
trixdhy
Starting Member
2 Posts |
Posted - 2012-04-18 : 22:13:46
|
quote:
Originally posted by sunitabeck
It may be that the servers are not linked correctly or it may be permissions issue, or something else. What is the error message you are seeing? Hard to speculate the reason without seeing that.
I don't use LinkedServer i just execute the query, When i execute in Server1 I Get this error : "error while converting data type varchar 'False' to data type Bit", But if i execute in Server2 it goes Fine nothing errorthanks before |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-19 : 00:55:57
|
quote:
Originally posted by trixdhy
quote:
Originally posted by sunitabeck
It may be that the servers are not linked correctly or it may be permissions issue, or something else. What is the error message you are seeing? Hard to speculate the reason without seeing that.
I don't use LinkedServer i just execute the query, When i execute in Server1 I Get this error : "error while converting data type varchar 'False' to data type Bit", But if i execute in Server2 it goes Fine nothing errorthanks before
thats because the values in server are not compatible with target table field. In SQL Server bit can hold only values 0 and 1 so if you want them as True, false etc you've to make target field type as varchar------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Error while Inserting Data