Keep it Simple and Smart
Hello 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 moreUNIQUE Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key value. A clustered index on a view must be unique. The Database Engine does not allow creating a unique index on columns
» Read moreFirst verify the “Distribute Transaction Coordinator” Service is running on both database server computer and client computers Go to “Administrative Tools > Services” Turn on the “Distribute Transaction Coordinator” Service if it is not running If it is running and client application is not on the same computer as the
» Read moreWhen multiple versions of the .NET Framework are executing side-by-side on a single computer, the ASP.NET ISAPI version mapped to an ASP.NET application determines which version of the common language runtime (CLR) is used for the application. The ASP.NET IIS Registration Tool (Aspnet_regiis.exe) allows an administrator or installation program to
» Read moreNokia Siemens Residential Router 1600 Port forwarding Quick Reference There are few very IMP URL for Port Forwarding A.) Please open –>Â http://192.168.1.1/main.html Go to Option NAT under Advanced if you don’t find option NAT under Advanced Option the go to Option B.) B.) For Virtual server –> 192.168.1.1/scvrtsrv.cmd?action=view For
» Read moreVarinder Sandhu is using WP-Gravatar