Database

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

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[^]

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

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

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

Member 245846721-Oct-13 18:58

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

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[^]

Mycroft Holmes21-Oct-13 19:04

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

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

Member 245846721-Oct-13 19:26

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

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[^]

Mycroft Holmes21-Oct-13 19:41

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

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

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

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

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

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

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

22-Oct-13 20:57

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

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.

Mycroft Holmes20-Oct-13 12:48

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

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

Mycroft Holmes20-Oct-13 23:16

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

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[^]

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.

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

Mycroft Holmes21-Oct-13 12:37