|
Many Time I am Also Suffer From this Problem but at a long time i find a solution
about this problem's.
First you Have To Change Window Authentication mode to mix mode authentication.
use Done this by Done From Inside SQL Server Object Explore\Properties\Security\Server Authentication Change to mix mode Authentication
or
by using Query run in Window Authentication mode
1)EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
2)Alter login sa enable
3)Alter login sa with password ='[abc]' --any Password
4)EXEC sp_revokelogin 'BUILTIN\Administrators'
5)Restart you'r SQL Server Service
and Batch File in C#.NEt is
int iChar = 34;
char aChar = (char)iChar;
StreamWriter sStr = new StreamWriter(GetWorkingDir + "//SQLSEREVR.Bat");
sStr.WriteLine("@echo off ");
sStr.WriteLine(@"CD\");
sStr.WriteLine(@"osql -E -S .\sqlexpress -Q "+aChar.ToString()+"Alter login sa enable"+aChar.ToString()+"");
sStr.WriteLine(@"osql -E -S .\sqlexpress -Q " + aChar.ToString() + "Alter login sa with password ='[abc]'" + aChar.ToString() + "");
sStr.WriteLine("Net stop " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + "");
sStr.WriteLine("Net start " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + "");
sStr.WriteLine(@"osql -E -S .\sqlexpress -Q " + aChar.ToString() + @"EXEC sp_revokelogin 'BUILTIN\Administrators'" + aChar.ToString() + "");
sStr.WriteLine("Net stop " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + "");
sStr.WriteLine("Net start " + aChar.ToString() + "SQL Server (SQLEXPRESS)" + aChar.ToString() + "");
string sBatchFileName = GetWorkingDir + "//SQLSEREVR.Bat";
|
|
|
|
|
Your DB? Is this DB on a server you do not own/admin? Have you asked the srvadmin?
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
Hi Experts
I Have A SQL Server 2005 Database i want that no body or person can copy my
.mdf file. i mean to say that no body can copy my .mdf file at attach at different
location for security issue. is their any way to protect to copy
or restrict the attachment of database at different location
Thank u
Dinesh Sharma
|
|
|
|
|
Yes. Upgrade to SQL 2008.
I kid you not.
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
|
|
|
|
|
I am using sql server 2005. I have a table like this
COL1 COL2
A 1
A 1
B 2
C 1
C 2
and i need output like this
COL1 COL2 No:
A 1 2
B 2 1
C 1 1
C 2 1
How many times the same COL1 and COL2 coming, that should be the column NO: in the output.. Please not that here i dont have any inputs like A,1 etc.... This is just the pattern, so i need a general quesry.
My small attempt...
|
|
|
|
|
What you need is a very simple select statement using grouping.
select Col1, Col2, count(col1) as No
from tablename
group by Col1, Col2
order by Col1, Col2
|
|
|
|
|
you are great
My small attempt...
|
|
|
|
|
hi all......
i got the solution... i think we can use the same technique which use for duplicate checking
SELECT COL1, COL2, count(*)
FROM table
GROUP BY COL1, COL2
i think this is fine
My small attempt...
|
|
|
|
|
Wow, looks remarkably like the answer I gave you 6 mins ago...
|
|
|
|
|
i seen your comment after i post my... anyway thanks...
My small attempt...
|
|
|
|
|
Hi
is it possible with cross query to do this ? (in Access 2007)
I have this table:
50 | A1
60 | A1
70 | B1
80 | B1
90 | C1
I need to get this result:
A1 B1 C1
sum | avg sum | avg sum | avg
110 | 55 130 | 75 90 | 90
|
|
|
|
|
50 | A1
60 | A1
70 | B1
80 | B1
90 | C1
I need to get this result:
A1 ------------------ B1 --------------- C1
sum | avg ----- sum | avg ----- sum | avg
55 | 110 --------- 75 | 130 ------ 90 | 90
|
|
|
|
|
No, it's not. What are you actually trying to achieve?
|
|
|
|
|
I try this:
TRANSFORM Sum(Worki.Value) AS XXsum
SELECT Worki.Name AS Name, Worki.Tdate AS Tdate, Worki.ID AS ID
FROM Worki
GROUP BY Worki.Name, Worki.Tdate, Worki.ID
PIVOT Worki.Trit;
but I how can I get the average ?
|
|
|
|
|
hi guys,
Any idea on how i can protect my sql 2005 view on a client site, in which others cannot see what the view does?
been trying to look around on google, but have not found anything.
thanks
Anoop
|
|
|
|
|
Give the view a schema prefix eg ABSystems.ViewName and use SQL security to restrict access to the view. This will not stop a quality DBA but will slow down the average user.
A DBA owns the database you are working on and as such will get access to your code somehow. I can think of 2 ways to get around this setup.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hi,
I have a program which does some operations with database.(Single tier architecture)
I will sometimes have to move the application to other systems having the database.
In order to make the database connection parameters configurable, i am storing the params such as username, password etc. in an xml file.
Is it the correct way to handle the situation?
If so will it be safe to store the database password in an xml file? how can i solve the issue?
If the application is meant for ordinary users(who may not have the database files), how can we approach the problem? Cconfiguration file will not be easy for him to edit no?
Thank you
Fadi
|
|
|
|
|
Fadi Yoosuf wrote: Is it the correct way to handle the situation?
There is no "correct way". It is a good idea to store it in a configuration-file, since it makes it easier to change.
Fadi Yoosuf wrote: If so will it be safe to store the database password in an xml file?
Yes and no. It might be safe on a NTFS-partition, depending on the settings. Passwords are rarely written into a file as plain text, so you could encrypt it if you wanted more security.
Fadi Yoosuf wrote: how can i solve the issue?
Switch to "Windows Authentication Mode", and you won't need to save a password. This would require just a small change in your connection-string. Use "integrated security" instead of the username/password combination.
I are troll
|
|
|
|
|
This is a standard approach and can be handled by using encrypted passwords, encrypting the config file or putting the password into the registry (not recommended these daya).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you very much for the info.
But I wish to know one more thing.
How huge applications like encyclopedias stores information?
If they store in database, how is it possible to install them, without having the database server in the system?
|
|
|
|
|
Fadi Yoosuf wrote: How huge applications like encyclopedias stores information?
These apps distribute a database with the app and are considered single user applications. A DB like SQL Express, Access or there are a few other small, single user databases out there.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I am using SQL Server 2005. I need to implement a full text search capability. I decided to use CONTAINS, and not sure if it is the correct statement to use. If the user types in word1 word2 in the search textbox, how would I send this to the CONTAINS statement? Something like word1 OR word2? What happens if he tries to search via phrase?
Please can someone help?
Regards
Brendan
|
|
|
|
|
You can use the CONTAINS -statement to search for pieces of text. It's not very usefull if you want to search for multiple parts; you'd have to check each text-column in each table for each word that the user types. Short example, we search our db for the text "Hello world".
Now, what should happen if table A holds this exact string, and table B has a text-field that starts with the word "World" and ends with the words "Hello, hello!"?
Worse, what happens when the user searches for the text "This is the world?" Would it find both records, or would it show those records that have the most occurences of the word "the"? These noise-words should be filtered to ensure relevant results.
All in all, FTS[^] isn't just a query you implement (although that can be starting-point for building your own), and most people that are using SQL Server resort to the text-indexing service of MSSQL[^].
You could also consider Lucene[^], there are some articles here[^] on CP on integrating it into your application.
Good luck
I are troll
|
|
|
|
|
Good Morning All
i have the Following Query
ALTER PROCEDURE [dbo].[sp_Staff_Select_NEW]
(
@lETTER CHAR(2)
)
AS
SELECT DISTINCT ID, DESCR, NOTE
FROM TBL_STAFF
WHERE LEFT(ltrim(rtrim(Descr)), 1) = @lETTER
ORDER BY Descr
--SELECT DISTINCT ID, DESCR, NOTE
--FROM TBL_STAFF
--WHERE SUBSTRING(Descr,1,1)= @lETTER
--ORDER BY Descr
As you can see there is a Commented part. Which one is more Faster between
SELECT DISTINCT ID, DESCR, NOTE
FROM TBL_STAFF
WHERE LEFT(ltrim(rtrim(Descr)), 1) = @lETTER
ORDER BY Descr
and
SELECT DISTINCT ID, DESCR, NOTE
FROM TBL_STAFF
WHERE SUBSTRING(Descr,1,1)= @lETTER
ORDER BY Descr
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hold on while I consult my crystal ball.
If you want to check the performance try putting a million records in a table with roughly equal number of initial letter and profile the two queries.
As an asside, your two queries may give different results as the one using the LEFT function ltrim and rtrim's whereas the SUBSTRING one does not.
|
|
|
|