|
Thank you for your first replys. I got some ideas.
But, of course, more replys are welcome 
|
|
|
|
|
we are using sql server 2008 in desktop application but client machine my database show i want database not show and secure my database please tell me what can i do.
thanks
badal
|
|
|
|
|
You can't "hide" your database, you need to apply authentication and authorisation to your database. This will limit what the user can see and do.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Best as I can tell from your question you are asking for something that is impossible.
SQL Server normally installs as an application. Thus it is ALWAYS visible on the client machine.
Now you could re-architect your application to use the embedded version of SQL Server (I think.) Then it would appear that only your application existed. I suspect this would require a bit of work. There are limitations to that approach.
Note as well that this has nothing to do with security. Security means something completely different.
|
|
|
|
|
Hi
My sql expired and remove it completely from my hard drive.
Sql Server 2008 r2 how Registry files deleted. Where do I find these files.
My Windows 7.
Thank you. 
|
|
|
|
|
C:\users\Myusername\ntuser.dat and c:\Windows\System32\config\
<edit>You probably shouldn't remove these files.</edit>
People say nothing is impossible, but I do nothing every day.
|
|
|
|
|
Goto registry search for: 10.50.1600.1 by select F3.
|
|
|
|
|
I want to insert only one row in a table in SQL server 2008 using C# ADO.Net...
If any user want to insert another row in that table then it is not possible message should be display....
Please Just reply the Query & CODE....
|
|
|
|
|
Why have you repeated this question a third time?
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
M.T.H.Danish wrote: If any user want to insert another row in that table then it is not possible message should be display....
Please Just reply the Query & CODE....
A database does not display messages, it holds data. It holds data in bulk, not in "single records". What you want does not make much sense from a data-viewpoint.
Now, this is not the place to "order" code like you do. The questions on the forums are answered by volunteers, in their free time. Put it in a object, serialize it, and stuff it in a single-column blob.
|
|
|
|
|
I want to insert only one row in a table in SQL server 2008 using C# ADO.Net...
If any user want to insert another row in that table then it is not possible message should be display....
Please Just reply the Query & CODE....
|
|
|
|
|
M.T.H.Danish wrote: If any user want to insert another row in that table then it is not possible message should be display
Take a look at locking a table:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/55452[^]
M.T.H.Danish wrote: Please Just reply the Query & CODE
I didn't downvote you, but I think most people here won't like to do your work. You can ask questions, you can show your code and ask for help, but you have to do your work on your own. So my answer is:
Definitely not!
------------------------------
Author of Primary ROleplaying SysTem
How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.
|
|
|
|
|
I want to create a table in which only one row should be insert.
If any user want to insert another row in that table then it is not possible...
Please just reply query...
|
|
|
|
|
Try using something like:
select count(*) from MyTable
if (count = 0) then
do insert
else
fail
|
|
|
|
|
Why would you need a table with just 1 row?
|
|
|
|
|
Try an INSTEAD OF TRIGGER
|
|
|
|
|
Make sure the Primary Key can only contain 1 value using a check constraint:
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [CK_OneRow] CHECK (([Id]=(1)))
|
|
|
|
|
Michael Potter wrote: Make sure the Primary Key can only contain 1 value using a check constraint:
ALTER TABLE [dbo].[MyTable] WITH CHECK ADD CONSTRAINT [CK_OneRow] CHECK (([Id]=(1)))
That is a very cool way to solve a very strange request. I'll give it a 5.
|
|
|
|
|
Super solution but can't be replicated in other databases like oracle.
Identity is a near equivalent to rowid concept in Oracle but its a dynamic value i.e not a sequence generator . Hence may be Only possible in sql server.
Regards
Sreeni
www.sreenivaskandakuru.com
|
|
|
|
|
If you change the start value of the identity seed (I'm pretty sure this can be done) and truncate the table the hard coded 1 would fail  mind you it is a silly request in the first place and I suspect the OP does not even know what you are talking about.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It may not be as useless as it first appears. I have used this method to hold global variables that are used by more than one application.
|
|
|
|
|
It'd be easier to create a view and be done with it;
CREATE VIEW GlobalSettingsTable AS
SELECT 1 AS ColumnName,
2 AS Nanana,
'C:\Program Files'
|
|
|
|
|
Yes - if your values are constants.
|
|
|
|
|
No, also for dynamic values; you can put sub-selects in there, or even calls to managed code
|
|
|
|
|
Don't get me wrong, I did not consider it useless (even in this idiotic context) just being a pedantic bastard.
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
