|
Here is google translator.[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
"An error occurred connecting to SQL server 2005. Unable to accept remote connections."
What you need to do is run the SQL Server Configuration Manager and make sure that protocol TCP/IP is enabled. Try that.
|
|
|
|
|
an error as occurred when connection to the server.
while connecting sql server 2005, this error is likely to be caused by, according to sql server setting, remote connections are not allowed
(provider: ... -there was not possible to connect to sql server
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi!
I had upgraded Visual Studio 2005 to 2008 and then upgraded SQL EXPRESS 2005 to SQL EXPRESS 2008. However, When I try to add a new "mdf" file under APP_Data directory. I am getting the following error message. How can I solve the problem? The Microsoft.Net Framework Version 3.5 SP1 and Microsoft SQL Server compact SP1 has been already installed.
ERROR MESSAGE
"Connections to SQL Server files (*.mdf) require SQL Server Express 2005"
Thanks.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Did you try to search on google[^]before post here?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Of course I did so that is why I decided to post the problem right here. You don't expect one to go and spend hours and hours the find the correct link related to problem in google right?
If you don't know the answer, please do not reply to my message.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
I know answer i am sure 100% but i wont give it to you.
Same problem i had too and i solved, so keep searching dude.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I will keep searching and you will mess up the forums. (DUDE!)
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
No,you are messing up forum with your beginners questions.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Where does it indicated that the forums are not for beginners? show me the link!
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
The link is with this subject on question:
"How can I solve SQL EXPRESS 2005 problem in Visual Studio 2008?"
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Your aim is not to help the others in this forum, therefore do not post any more messages. Take a long walk. I think you are experiencing some sortf of behaviour problems.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
|
if i use varchar(max) instead of varchar(50), and use "chandra" only , then will both give the same performance.
“You will never be a leader unless you first learn to follow and be led.”
–Tiorio
"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford
|
|
|
|
|
I assume your question is 'will they give the same performance?' - if so the answer is yes.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
well,
i use varchar(max) for very long strings, that i don´t know the size
i use varchar(50) if i know the string never goes of that border
var means variable, so is from 0 to 50.
if you know you only need 3 chars you use char(3)
if you need 0,1,2 or 3 chars you use varchar(3)
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I just joined a company that uses SQL 7.0,which am not that much used too.
i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS
and can view triggers and other objects with 'sysobjects'
i want to view the code for the triggers in a particular table...
PLEASE HELP ME...THANKS
|
|
|
|
|
OK, so I have a table of businesses. Then I have a table of contacts. So, I have many contacts for the one business. I want to do a search, and use a contact name as a possible search. However, I don't ever want to return the same business more than once. So, I want to return each business that matches at least one contact, with any contact that matches. I've tried putting in a subquery so that I select the top 1 contact for a business, but I can't find a way to write SQL that works.
select
c.IDClient, c.Company, con.LastName + ', ' + con.FirstName as Contact, c.Phone, c.Fax
from tbl_client c
inner join tbl_client_contacts cc on cc.IDClient = c.IDClient
inner join tbl_contact con on con.IDContact = cc.IDContact
where con.IDContact = (select top 1 IDContact from tbl_client_contacts ccc where ccc.IDClient = c.IDClient)
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
SQL query seems ok.Your query don't return data or what?
Have you try to specify table name for column IDContact inside subquery?
<br />
select<br />
c.IDClient, c.Company, con.LastName + ', ' + con.FirstName as Contact, c.Phone, c.Fax<br />
from tbl_client c<br />
inner join tbl_client_contacts cc on cc.IDClient = c.IDClient<br />
inner join tbl_contact con on con.IDContact = cc.IDContact<br />
where con.IDContact = (select top 1 ccc.IDContact from tbl_client_contacts ccc where ccc.IDClient = c.IDClient)
Hope it will help.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Brilliant, that was the issue ( my old code would not even compile ). Thanks for the help, I appreciate it.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Never mind dude,I am glad that helped you.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi,
I am using sql server 2005 and ASP .Net 2.0, VS 2005.
When I increased a parameter in Stored Procedure and in application, and again running the application it throws an error that, Parameters does not match with the stored procedure parameters.
All i have to do is restart the machine and again run the application. Then it does not throw the error and it works fine with the extra parameter in application as well as in storedproc.
I am unable to understand what is the exact problem, that i have to restart the machine and then it accepts the changes
|
|
|
|
|
I think you'll find it has to do with the way you are running the ASP for development, sound like ASP is cacheing the footprint and rebooting clears out the chache.
Try asking in the ASP forum, they may be more helpful.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I saved a data import task to a SSIS package in MSDB. SQL Server 2005.
Now how can I access that again??? I want to make an automatic task to upload files from a folder to tables??
Dont we have something easy and useful like DTS in SQL server 2005???
Keep DotNetting!!
GeekFromIndia
|
|
|
|
|
I can understand your angst, I knew DTS, it worked well and it was fairly simple. But they (MS) have moved on and inflicted us with SSIS, there is no going back.
Alternatively you can write your own ETL solution. This is what we did rather than use SSIS.
Never underestimate the power of human stupidity
RAH
|
|
|
|