Script(s)

technology as-is

February 29, 2008
by gchandra
0 comments

Microsoft Patterns & Practices Enterprise Library Step by Step tutorials

Microsoft Patterns & Practices Ent Lib 3.1 can be downloaded from the link below. http://msdn2.microsoft.com/en-us/library/aa480453.aspx These blocks are very useful and efficient. I tried to find step-by-step hands on tutorial for this version but was able to get only for … Continue reading

February 28, 2008
by gchandra
0 comments

How to Query Active Directory using LDAP in SQL Server 2000 / 2005 ?

Step 1:- Add a linked server for the Active Directory exec sp_addlinkedserver ‘ADSI’, ‘Active Directory Services 2.5’, ‘ADsDSOObject’, ‘adsdatasource’ Step 2 :- Then follow the steps mentioned here for setting up permissions. Step 3 :- You can query the Active … Continue reading

February 22, 2008
by gchandra
0 comments

Disable .xml file generation when building Asp.Net application

Visual Studio 2005 – Compile Options .XML files are used to create Documentation. If you need to disable them, then Project Properties > Compile and Uncheck Generate XML Documentation file option.

February 22, 2008
by gchandra
0 comments

Disable .pdb file generation in Release Mode

Visual Studio 2005 – Compile Options In Visual Studio 2005, .pdb file gets generated in Debug mode and Release mode. In debug mode it loads the entire symbol table, in Release mode it loads the key symbols. In Release mode, … Continue reading

February 18, 2008
by gchandra
0 comments

SQL Server 2005 : Access Tables / Entities across Servers.

Accessing objects (tables..) across servers (SQL Server) is very simple. Step 1: Create a link between two servers Goto Query Window [sourcecode language=’sql’] EXEC sp_addlinkedserver    ‘PRODSVR’,    N’SQL Server’ GO[/sourcecode] ‘PRODSVR’  is the name of the Server.Execute it. Step … Continue reading

February 18, 2008
by gchandra
0 comments

SQL Server, Clean your Database Records and reset Identity Columns, The Shortest Path

(Copied from Moses’s Blog for my reference) Well, I had a small issue regarding writing a script to clean a database we have and reset its identity columns in all tables. Although the database wasn’t huge one (less than 100 tables) … Continue reading