|
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
|
|
|
|
|
ok but a forgot my sa password
by anyway i re install sql server and recreate creds
thanks anyway
|
|
|
|
|
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 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
I just know I am going to need that sometime in the future, thank you.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
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  
|
|
|
|
|
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[^]
thatrajaNobody remains a virgin, Life screws everyone 
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
I believe that one more table will not hurt (and no such thing that one time)...
But,
you can write also CASE like this:
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).
|
|
|
|
|
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
|
|
|
|
|
|
Quote: The description values are not in a table
SQL is designed to handle table data - so if you have a list of codes with descriptions, then put them into a table and join it to get the description.
For instance:
PERSON table
id name status
1 Peter 2
2 mrfalk 1
3 Larry 3
MOOD table
code description
1 Happy
2 Sad
3 Mad
SELECT ID, NAME, DESCRIPTION
FROM PERSON
LEFT JOIN MOOD ON CODE = STATUS
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is (V).
|
|
|
|
|
|
codestar007 wrote: Need suggestion from you guys..
My first suggestion would be to not crosspost. It feels as if you're simply not satisfied with the answers already given there.
The person owning the database-server will be the owner of the database and hence, of the data. It's not "your" database. Password-policies aren't going to help; the local admin is in charge. You could encrypt your TSQL procedures, just for fun.
If you're afraid someone steals your design then don't give away the database. Host it yourself on a server and provide some webservices to it. Call it a cloud if you want.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hi,
We have two different production environments, in literally two different locations physically, with the same table layouts. For purposes of data warehouse, the two environments.
I want to copy over data from server 1 to server 2. The table has only 4000 rows. The date format of this data is of the form
2013-10-01 10:28:35.560 . so, i worry if I try to export this data into excel from server 1 and try to import this data back into server 2's table if I would lose any of the information.
What would be the best way to copy over the table?
Thanks so much!
|
|
|
|
|
Is this a one time or daily.
If daily think about replication.
Can the two systems talk to each other? If you must export to a table one option would be .CSV which would not loose the data like Excel will.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
