Solved

i created SQL server 2008 database and connect it through SQL studio manager 2008

Posted on 2013-12-03
2
239 Views
Last Modified: 2014-01-19
and i attached two databases to him with different database name
now i have a program with open code and i run it and it success to connect but when i enter user and pass its return "database return more then one line" something like that and it failed to connect

what could be the reason that i am receiving duplicate replay?

please advice
Thanks
Gvilbis
0
Comment
Question by:gvilbis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Assisted Solution

by:Zberteoc
Zberteoc earned 250 total points
ID: 39693687
I think there is a subquery that returns more than 1 row but we need to see what query is executed.
0
 
LVL 9

Accepted Solution

by:
QuinnDex earned 250 total points
ID: 39693970
another reason could be a duplicate row in the database you will have to check for that,

as Zberteoc says we will need to see the actual query to be able to help you with a possible query error
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
converting integer data type to time data type in sql 4 60
Disable TLS1.0 on Win 2012 server 7 117
point in time restore in SQL server 26 54
Need a mirrored QA test site 2 95
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question