Reputation
Top tag
Next privilege 75 Rep.
Set bounties
Badges
3 6
Newest
 Commentator
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Nov
22
revised Password protected Database Engine with Server features and Store procedure
added 267 characters in body
Nov
22
awarded  Commentator
Nov
22
comment Password protected Database Engine with Server features and Store procedure
Thank you, but its Enterprise version has this feature which is not cheap enough for medium size app. Do you know any alternative DB engine?
Nov
22
comment Password protected Database Engine with Server features and Store procedure
@Erik, I don't like that others could see the database structure and data. We can set a password for Microsoft Access database and then nobody can open it. But in MS SQL server (unless its Enterprise version) does not this lind of password protection.
Nov
21
revised Password protected Database Engine with Server features and Store procedure
added 154 characters in body
Nov
21
awarded  Editor
Nov
21
revised Password protected Database Engine with Server features and Store procedure
added 2 characters in body
Nov
21
revised Password protected Database Engine with Server features and Store procedure
added 2 characters in body
Nov
21
asked Password protected Database Engine with Server features and Store procedure
Nov
27
awarded  Notable Question
Jun
13
awarded  Notable Question
Aug
19
awarded  Notable Question
Jul
15
awarded  Popular Question
Nov
10
awarded  Popular Question
Oct
20
awarded  Popular Question
Jun
24
comment Extract mdf & ldf files from backup file?
I have many customers and sometimes they give me backup for fix some issue. I want to restore their backup as ms sql files and use them in local file without attaching to sql server (connection runtime attaching)
Jun
24
asked Extract mdf & ldf files from backup file?
Jun
6
comment sql server , set N prefix as unicode for all queries by default
The SQL queries passed from c# by string but it prepare parameterizing! We are talking about SQL server which dose not trust themself. It s very easy to undrestand, When I declare a field as Nvarchar so sql must save as unicode!
Jun
5
comment sql server , set N prefix as unicode for all queries by default
What you mean of 'declare the variables as a unicode'? if you mean pass the unicode string, so When I pass my sql query to sql server without N prefix, the sql server save my values as default characters (non unicode) and when I get that values, it returns all characters as default chars (non unicode) and these all are not depond on my c# variables type!
Jun
5
comment sql server , set N prefix as unicode for all queries by default
@AaronBertrand , When I set type of my field to nvarchar, so I decided to save values as unicode, isn't it? well, why we need use N prefix for unicode fields? yes that is boring and if you don't know I have to tell you that there are other queries except select query, so the select keyword is not boring.