Category: Varinder Sandhu
SQL – Index
UNIQUE 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 moreThe partner transaction manager has disabled its support for remote/network transactions
First 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 moreASP.NET IIS Registration Tool – Aspnet_regiis.exe
When 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 morePort Forwarding Quick Reference
Nokia 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 moreAre You Satisfied with Windows 7?
Mobipocket Reader
Hello Friends, I have tried the Utility Mobipocket Reader it really helpful for me…. That’s why I am sharing with you all … Mobipocket Reader easiest way to build, organize, read and annotate your entire eBook library. Get the Mobipocket eBook Reader on your Windows PC – it’s free –
» Read moreASP.NET SQL Server Registration Tool – Aspnet_regsql.exe
This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to
» Read moreList of datatypes in SQL Server
We are using very few data type in SQL Server like INT, varchar,datetime etc But there are currently 37 datatype supported by SQL Server 2008 See the below scripts exec sp_datatype_info select * from sys.types exec sp_datatype_info_90 exec sp_datatype_info_100
» Read moreDifferences Between XHTML And HTML
XHTML is not very different from the HTML 4.01 standard. The Most Important Differences: XHTML elements must be properly nested XHTML elements must always be closed XHTML elements must be in lowercase XHTML documents must have one root element For more detail Click here
» Read more