Database

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

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.

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

Importing rss feed to openoffice

21-Oct-13 12:37

I just know I am going to need that sometime in the future, thank you.

Never underestimate the power of human stupidity
RAH

joestudent1219-Oct-13 4:57

joestudent12

19-Oct-13 4:57

I have been searching the far reaches of the web trying to find a way to import all of my rss feeds into openofice base. From what I have gathered so far is that it is possible with VBA code but could not find it anywhere. I think this should not be that difficult.

Also, I have been trying to find a way to forward emails to same database. Is there a way to setup a database email address to send mail to? I have already tried to forward the emails to rss feed but that is not without errors.

Please assist me in anyway, thank you.

SQL 2005 LOG FILE SIZE 70.1 GB

Nilesh D Sonpasare18-Oct-13 21:55

Nilesh D Sonpasare

18-Oct-13 21:55

I AM USEING TO SHIRNK LOG FILE "DBCC SHRINKFILE (COLLEGE_log, 5)"
BUT ITS NOT WORKS.

Please tell me any suggestion.

Regards,
Nilesh

modified 19-Oct-13 4:03am.

Re: SQL 2005 LOG FILE SIZE 70.1 GB

codestar00719-Oct-13 2:27

codestar007

19-Oct-13 2:27

You can have a look at this once
how-do-i-decrease-the-size-of-my-sql-server-log-file[^]

can not connect to oracle database express

mrfafa18-Oct-13 20:09

mrfafa

18-Oct-13 20:09

hi my friends ,,, i created a program that work with c# and oracle database express in A system ,,, when i want to run this software in B system ,,, the C# side of my software con not connect to the oracle database side
i dont want install oracle database express in B system ,,, please help Frown | :(

Re: can not connect to oracle database express

thatraja19-Oct-13 1:42

thatraja

19-Oct-13 1:42

mrfafa wrote:
the C# side of my software con not connect to the oracle database side

You didn't share any error details. Always include that in your question.

Where did you store the connectionstring? in web.config file? Then make sure you're using the right host. Check these
Remote ORACLE server connection string[^]
Oracle connection strings[^]

thatraja

FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion
HTML Marquee & its alternatives

Nobody remains a virgin, Life screws everyone Sigh | :sigh:

SQL Select Statement ?

mrfalk16-Oct-13 11:32

mrfalk

16-Oct-13 11:32

I have a sql select statement that returns a list of codes and I need to edit the results to reflect the description of the codes.

For example:

Code = Description
1 = Happy
2 = Sad
3 = Mad
etc...

So how do I translate my code values to the description values in SQL? The description values are not in a table and would need to be hard-coded in the sql statement.

Hopefully this questions makes sense. I tried google before posting with limited results because I'm not sure if what I am asking can be done.

I'd appreciate any assistance!

Thanks!

Mycroft Holmes16-Oct-13 12:48

16-Oct-13 12:48

mrfalk wrote:
The description values are not in a table

That is where your error is, the description should be another column in the table, that why you will not find a sensible answer to your searches it just is not correct to put the description anywhere but the table.

Never underestimate the power of human stupidity
RAH

mrfalk16-Oct-13 13:13

mrfalk

16-Oct-13 13:13

This is a one-time extract for a third party vendor who requires us to translate our code to their description. I'd rather not create a table in my production environment for one-time use.

Kornfeld Eliyahu Peter16-Oct-13 20:06

Kornfeld Eliyahu Peter

16-Oct-13 20:06

I believe that one more table will not hurt (and no such thing that one time)...
But,

you can write also CASE like this:

SQL

CASE CODE
  WHEN 1 THEN 'HAPPY'
  WHEN 2 THEN 'SAD'
  WHEN 3 THEN 'MAD'
END

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).

Mycroft Holmes16-Oct-13 22:01

16-Oct-13 22:01

mrfalk wrote:
This is a one-time extract

There is no such thing, whichever method you use (mood table, case query) make sure you retain the script, you WILL need it again!

Never underestimate the power of human stupidity
RAH

PIEBALDconsult18-Oct-13 13:26

PIEBALDconsult

18-Oct-13 13:26

Words to the wise.