Sql Server Management Studio) and from direct exe too though it is not responding.Can any one give me the reason and solution behind it.I am using sql server 2008 that is installed on Windows Server 2003...

It is very small point but developers are unaware of it that's why i am sharing it here. Len function in sql server returns total no of characters in any string which is passed to it as a parameter,but it excludes trailing blanks example select ...

there is not any fixed reason i just don't want to show database structure to other or you can say that i don't want to give rights to any one to just copy my table structure or concept. so is there any way to do this....

ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($) after getting one bug i learn this from bol...

Thanks jacob for your reply, but my question is still same that how can i protect my database so that no one can check table structures of it.because it is easy to encrypt procedure and views, but how can i hide my table structure.your solution is go...

You can achieve this using below mention query.but you must follow jacob's suggession and remove duplicate values from front end. Declare @state as table( [State] Varchar(100),Country varchar(100)) declare @city as TAble (City varchar(100),...

I want to know what are the best ways to secure objects of database or to secure any database.Here the term objects means procedure,table,functions view.Can we do something so that user can not open or get these objects from windows authentication and s...

I want to know what are the best ways to secure objects of database or to secure any database.Here the term objects means procedure,table,functions view.Can we do something so that user can not open or get these objects from windows authentication and s...

Thanks Nakul & Jacob I will go with your suggestion,but can you give me basic or standard server configuration that is required so that i can do test on it....

Can any one suggest me best hardware requirement(server machine requirement) for using sql server 2008 r2.I am going to use 3 database and reporting services on save server and will be having more than 100 user.Apart from it i want to access database fr...