Re: How to copy table data SQL 2005 Express fastest ? - Database Discussion Boards

Re: Problem Connecting To SQL from SOME Machines

jschell24-Oct-13 7:47

jschell

24-Oct-13 7:47

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.

How to insert data in the tables

lichengjuan-421-Oct-13 18:39

lichengjuan-4

21-Oct-13 18:39

I have built a table in the database.But what is the reason that I can't insert data.

Re: How to insert data in the tables

Mycroft Holmes21-Oct-13 18:44

Mycroft Holmes

21-Oct-13 18:44

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

Re: How to insert data in the tables

Amol_B23-Oct-13 20:37

Amol_B

23-Oct-13 20:37

If you need help, you have to answer a proper question first

Re: How to insert data in the tables

coded00725-Oct-13 3:19

coded007

25-Oct-13 3:19

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. Smile | :)

Mani Prabhakar

Re: How to insert data in the tables

rashin ghodratzade28-Oct-13 6:51

rashin ghodratzade

28-Oct-13 6:51

in sql you have use from :
INSERT INTO table name VALUES ( , , ,

How to copy table data SQL 2005 Express fastest ?

Member 245846720-Oct-13 19:48

Member 2458467

20-Oct-13 19:48

For example i want to copy table TabUsername the Northwind database into databases QLKD, how ? you see attachments file

http://www.crocko.com/DD5D9C792D224FBDAF7F78E130E478FE/CopyTable.jpg[^]

Re: How to copy table data SQL 2005 Express fastest ?

Jörgen Andersson20-Oct-13 21:43

Jörgen Andersson

20-Oct-13 21:43

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

Re: How to copy table data SQL 2005 Express fastest ?

Mycroft Holmes20-Oct-13 21:55

Mycroft Holmes

20-Oct-13 21:55

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

Re: How to copy table data SQL 2005 Express fastest ?

Member 245846721-Oct-13 18:58

Member 2458467

21-Oct-13 18:58

I do not, it's warning eror, Northwind have got 2 filed username: nvarchar(50) and passwords: nvarchar(50). you see my attach file http://farm4.staticflickr.com/3699/10416257853_49e6c5364f_m.jpg[^]

Re: How to copy table data SQL 2005 Express fastest ?

Mycroft Holmes21-Oct-13 19:04

Mycroft Holmes

21-Oct-13 19:04

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

Re: How to copy table data SQL 2005 Express fastest ?

Member 245846721-Oct-13 19:26

Member 2458467

21-Oct-13 19:26

My pictures on flickr see normal but you told me link no work. you see link below
http://upfile.vn/ef2e[^]

Re: How to copy table data SQL 2005 Express fastest ?

Mycroft Holmes21-Oct-13 19:41

Mycroft Holmes

21-Oct-13 19:41

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

Re: How to copy table data SQL 2005 Express fastest ?

Jörgen Andersson22-Oct-13 3:47

Jörgen Andersson

22-Oct-13 3:47

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

Re: How to copy table data SQL 2005 Express fastest ?

PIEBALDconsult22-Oct-13 3:39

PIEBALDconsult

22-Oct-13 3:39

Mycroft Holmes wrote:
on the same server

And in the same instance too.

Re: How to copy table data SQL 2005 Express fastest ?

Mycroft Holmes22-Oct-13 4:46

Mycroft Holmes

22-Oct-13 4:46

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

Re: How to copy table data SQL 2005 Express fastest ?

PIEBALDconsult22-Oct-13 4:15

PIEBALDconsult

22-Oct-13 4:15

Re: How to copy table data SQL 2005 Express fastest ?

jschell22-Oct-13 8:00

jschell

22-Oct-13 8:00

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.

Re: How to copy table data SQL 2005 Express fastest ?

Member 245846722-Oct-13 20:57

Member 2458467

22-Oct-13 20:57

SQL 2005 Express no import/export, you see attachfile "http://www.flickr.com/photos/106210615@N05/[^]"

Re: How to copy table data SQL 2005 Express fastest ?

jschell23-Oct-13 9:28

jschell

23-Oct-13 9:28

Member 2458467 wrote:
SQL 2005 Express no import/export,

Following would suggest otherwise

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/546f4407-0aa4-4b04-96f3-e6f0ba39a9d1/importexport-data-with-sql-server-2005-express?forum=sqltools[^]

fail to login in sql authentication mode

mhd.sbt20-Oct-13 5:52

mhd.sbt

20-Oct-13 5:52

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.

Re: fail to login in sql authentication mode

Mycroft Holmes20-Oct-13 12:48

Mycroft Holmes

20-Oct-13 12:48

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

Re: fail to login in sql authentication mode

mhd.sbt20-Oct-13 22:26

mhd.sbt

20-Oct-13 22:26

ok but a forgot my sa password
by anyway i re install sql server and recreate creds
thanks anyway

Re: fail to login in sql authentication mode

Mycroft Holmes20-Oct-13 23:16

Mycroft Holmes

20-Oct-13 23:16

mhd.sbt wrote:
ok but a forgot my sa password

Then yes the only solution is to re install. I think there may be a way to recover the sa but I don't know.

First thing I do when setting up is create 2 sa users and put the creds into passwordsafe having lost the sa password in the past Blush | :O

Never underestimate the power of human stupidity
RAH

Re: fail to login in sql authentication mode

Richard Deeming21-Oct-13 3:28

Richard Deeming

21-Oct-13 3:28

Mycroft Holmes wrote:
I think there may be a way to recover the sa but I don't know.

http://blogs.msdn.com/b/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx[^]

Stop the SQL service;
Start SQL in single-user mode with the -m parameter;
Log in using a local administrator account;
Add your account to the sysadmin role and/or reset the sa password;
Re-start SQL without the -m parameter;

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.