Keep it Simple and Smart
Dear 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 moreHello Friends, I have faced a problem using SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY with Linked server Let me explain with example as below Question: We have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now
» Read moreHello Friends, I have tried the Utility Bullzip PDF Printer, it really helpful for me…. That’s why I am sharing with you all … Introduction The Bullzip PDF Printer works as a Microsoft Windows printer and allows you to write PDF documents from virtually any Microsoft Windows application. This program
» Read more— To allow advanced options to be changed EXEC sp_configure ‘show advanced options’, 1 GO —- To update the currently configured value for advanced options. RECONFIGURE GO —- To enable the feature. EXEC sp_configure ‘xp_cmdshell’, 1 GO —- To update the currently configured value for this feature. RECONFIGURE GO Alternative way 1. Click the Start button. 2. Select All Programs. 3. Navigate to the Microsoft SQL Server 2008 folder. 4. Right Click on Server
» Read moreThe beginning of the new year is a great time to start fresh and work toward the things that you want from life. Pretty much everyone sets goals and objectives for the new year whether privately in their
» Read moreDear and Respected All, I am pleased to announce that Yesterday (27-December-2010) I have passed the examination of Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development. For more details about this exam 70-433: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us
» Read moreVarinder Sandhu is using WP-Gravatar