|
|
|
"The server's IP/Port are hardcoded in (to test), so that hasn't changed."
And that's a public IP address somewhere on the web where it can be reached without restrictions? Or is it something like 192.168.0.42?
|
|
|
|
|
Bernhard Hiller wrote: And that's a public IP address somewhere on the web
Given that the OP said that it worked a couple of days ago and hasn't changed it thus follows that it is a public address.
|
|
|
|
|
I have built a table in the database.But what is the reason that I can't insert data.
|
|
|
|
|
Telepathy is a wonderful concept but it just doesn't work properly!
What database?
What is the error message?
What is you UI?
Just a little more information may help someone make a guess at the problem.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
If you need help, you have to answer a proper question first
|
|
|
|
|
Can you please give us more details like UI code that you are using, Table Structure etc... so that we can help you to cross your obstacle. 
Mani Prabhakar
|
|
|
|
|
in sql you have use from :
INSERT INTO table name VALUES ( , , ,
|
|
|
|
|
|
I'm not going to click any link what so ever containing the words crocko.com
You'd better store your picture on flickr or picasa or something similar, before your post or even account get voted as spam and disabled.
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
If they are on the same server use SSMS.
Select *
into DatabaseName.dbo.DestinationTableName
from DatabaseName.dbo.SourceTableName
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
That answer does not seem to relate to the original question. The image link does not work!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Sorry my net nazi won't allow access to that site.
Just type out the error message like everyone else instead of faffing around with images!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Pictures uploaded to Flickr are by default set as private.
Log into Flickr and set the permissions and the link will probably work.
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
Mycroft Holmes wrote: on the same server
And in the same instance too.
|
|
|
|
|
PIEBALDconsult wrote: And in the same instance too
Assumed I think installing multiple instances are a little beyond the OPs skills.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
If you mean SQL Server 2005, and if you have SSMS (which you should), you can use that to do it.
Right-click on the source database | Tasks | Export data... | Next | Select the destination server (instance) and database | Next | Next | Select the table(s) to copy
you should be able to go from there.
|
|
|
|
|
Depends on what you mean by "fastest".
If you mean the way that takes you the least amount of time then it depends on your experience.
If you mean something where there are large amounts of date, then database import/export tools are often fastest. If small amounts of data then any mechanism will likely take the same time as any other.
|
|
|
|
|
|
|
hi to all
i want to login in sql server in windows authentication mode but
i delete my user login(domanin\myname)
how can i login without this user name in sql authentication mode ?
thanks in advanced
modified 20-Oct-13 12:12pm.
|
|
|
|
|
Go to your SA and get them to re create your login again, prepare to be berated as an idiot!
How do you expect to be able to logon if you have delete the credentials.
If it is your server then use another set of creds (you do have the sa creds don't you) which have rights to security and recreate your integrated creds.
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
