Keep it Simple and Smart
We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly. There are four system databases available in SQL Server 2008 Master Model msdb tempdb Master Database The master
» Read moreHello Friends, I have setup the Linked server with the help of script here. My one of colleague helps me to write the script with we can map all user with one statement. This script will map all local SQL server users with remote user that you provide in the
» Read moreWhat is default Isolation level for SQL Server 2008 or Crystal Report? Many people have same above question about Isolation Level, may we have same question. So here share the brief answers of this question. Transaction Isolation Level: In database systems, isolation is a property that defines how/when the changes
» Read moreDear Friends, I have tried the Utility SQL Search, it is really helpful for me… Thought it will be handy to all of us and it is a free tool from Red Gate. SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL
» Read moreDear friends Most of time we have a question about difference between the SQL server editions, Lot of detailed stuff available over the internet but here sharing with you the brief information about the each SQL server editions so that we can understand easily about all the editions. SQL server
» Read moreDear friends, A new release of SQL Server is available, and if you follow blogs or tweets or check Microsoft’s SQL Server website. You might have seen mention of the new version, code-named “Denali” SQL Server 2011 – CTP1 Released. CTP stands for Community Technology Preview It’s available in both
» Read moreHello Friends, I have faced a problem in SQL queries with Linked server; I just want to share with you all. Let me explain with example as below Say, we have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set
» Read moreOnce you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the users. The problem is that the user in the database is an “orphan”. This means that there is no login id or password associated with the database user So
» Read moreIdentity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But sometime Identity columns missed the value, we want to insert missed value into the column. For that we need to enable IDENTITY_INSERT for the table. USE mytempDB
» Read moreHello Friends Generally, we choose the @@VERSION to get the version information for SQL Server, but using this function we can’t get the Service Pack information installed… Alternative way Get Editions of SQL Server SELECT SERVERPROPERTY(‘EDITION‘) AS EDITION Get Version Detail of SQL Server SELECT SERVERPROPERTY(‘PRODUCTVERSION‘) AS VERSION Get the
» Read moreVarinder Sandhu is using WP-Gravatar