|
if you can't take Mika's reply and apply it to your requirement then you need to do some thinking about what you are doing - he supplied a solution days ago. I give up, some people are just too lazy for words.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
U know i find the solution . thanku for your Stupid answers
you are only time wasted...............ok
|
|
|
|
|
|
One thing about forums is that when people answer you, it may not always be the kind of answer you expect. However, the answer is still meant to help you forward.
The worst thing you can do is that you start to offend the very people that put their own precious time to voluntary work in order to help other people.
Think about it: what kind of treatment would you expect the next time you ask for help if you start mocking the answers given to you.
So my advise is: Read the given answers, analyze them neutrally in your mind and learn from them. This helps you both in understanding technical issues but also to get answers more efficiently when working with forums.
|
|
|
|
|
Oh! And you are a jack*ss. NO ONE WILL HELP YOU NOW.
|
|
|
|
|
Yeah, you are not going to get ANY help at this point.
|
|
|
|
|
Hi,
I have created a dts package. all the values like Source Data connection, source userid and source pwd is passed through variables and for destination database all these values are hardcoded.
At design time I used a DSN which points to SourceServer1. Using this DSN it stores mapping between source and destination at design time.
After this I executed this pakage with the same DSN it worked perfectly but when I changed datasource of the destination from SourceSrver1 to SourceServer2, I am geeting error "SourceServer2 is not same as the SourceServer1". When I am passing all the connection info using global variables then why it is looking for the connection info that I provided at design time?
It's very urgent, any help is deeply appretiated.
Thanks in Advance.
CodeManiac
xxxxxxxxxx
xxxxxxxxxx
|
|
|
|
|
Hey there!
I am trying to create a connectionstring to SQLServer 2005. The server uses only windows athentication. I am now writing an application that uses a .NET Data provider for SQL Server. Using the following connectionsstring is working:
Data Source=Server\inst01;Initial Catalog=TestDB; Integrated Security=SSPI;
What happens is that the user that is currently logged in, is also connecting to the database. My issue is now, that I want to connect to the database with a different user as the one logged in to windows. The user should provide user name (including domain) and password in my application and I want to build a connectionsstring so that the logged in user can connect to the database as a different user.
How must the connection string look like? Is ist possible at all?
Thanks,
Florian
modified on Monday, February 16, 2009 3:48 PM
|
|
|
|
|
I don't understand good enough your question but take a look this link http://www.connectionstrings.com/[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Thanks, I had a long look at this. But it did not give me an answer.
What I want to do is the following: I want to connect to a SQL Server database with a special user that is not the user currently logged on to windows. And I do not have the option of configuring SQL Server logins only Windows Authentication can be used.
I hope I could make it a little bit clearer what I want.
|
|
|
|
|
You can confugure SQL Server to use Mixed Mode[^] which include Windows and SQL Server authentication.
Diving Albi wrote: I want to connect to a SQL Server database with a special user that is not the user currently logged on to windows
Then use username and password which are stored in your database.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Unfortunately I do not have the chance to setup mixed mode. I think I will go for Mikas solution.
Thank you anyway. 
|
|
|
|
|
|
Thanks! The links are very helpful. This is the way I am going!!
|
|
|
|
|
|
how to use lock concept in sql server 2005?
pls send some examples urgent......
|
|
|
|
|
Google "sql server 2005 locking"
Regards
David R
|
|
|
|
|
I want to Delete Duplicate records From a table except the Max(ID)Using Full Text Query.
and
Duplicate records are just certain field
not an entire row in a table.
and
I have millions of records in my table.........
|
|
|
|
|
Muhammad Fahim Baloch wrote: I want to Delete Duplicate records From a table except the Max(ID)
You should be more specific how you define duplicate. Obviously you wnat to save the latest, but what's duplicate for you in this case.
Muhammad Fahim Baloch wrote: Using Full Text Query
How does this relate to duplicates?
Muhammad Fahim Baloch wrote: Duplicate records are just certain field
Which fields? It would be easiest if you provide a dessciption of the table and tell that based on what columns you want to observe the duplicates.
Muhammad Fahim Baloch wrote: I have millions of records in my table
And how does this relate? Concerned about the speed perhaps?
|
|
|
|
|
I have a table, which has two rows
1.EmailID
2.EmailAddress
I have Duplicate Email Addresses and i want to Delete Duplicate Email Addresses from my table except the max(emailId)
and I have millions of Duplicate EmailAddresses in my table
Plz ans me as soon as possible....
Thanks!
|
|
|
|
|
Muhammad Fahim Baloch wrote: I have Duplicate Email Addresses and i want to Delete Duplicate Email Addresses from my table except the max(emailId)
You could try something like:
delete from YourTable
where exists (select 1
from YourTable alias1
where alias1.emailaddress = YourTable.emailaddress
and alias1.emailid > YourTable.emailid)
Remember to use begin transaction so that you can rollback if the result isn't what you wanted.
Muhammad Fahim Baloch wrote: and I have millions of Duplicate EmailAddresses in my table
This means that unless you have proper indexing this will take a while.
|
|
|
|
|
Hi
Thnks a lot..............................
Thanku agian.............................
You are doing greate job
Thanks agian,,,,,,,
By
|
|
|
|
|
hi
can anybody tell me about the normalization
thanks
Hemant
By:
Hemant Thaker
|
|
|
|
|
A normalized database (which is a good idea generally) typically means that the minimum amount of data is stored (no repetition) in a relational manner. Take a look here for more info...
http://en.wikipedia.org/wiki/Database_normalization[^]
Regards,
Rob Philpott.
|
|
|
|
|
Hi
I need to put 'abs' for students absent in a review
for exemple of the material which the code is 121 .
I have the following query:
SELECT id_student, CASE WHEN (CODE) = 1 THEN 'Abs' ELSE [121] END AS m1,
[122] AS '2', [123] AS '3'
FROM (SELECT id_field, id_student, NOTE, CODE FROM TEST)
p PIVOT (sum(NOTE) FOR id_field IN ([121], [122], [123])) AS pvt
ORDER BY id_student
I have the error here CASE WHEN (CODE) = 1 THEN 'Abs' because [121]is the type float and 'abs' is a text how to solve this?
Thanks!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
