Read this article..
In Asp.net 2.0 multiple connectionStrings & appSettings can be handled very easily using the attribute “configSource”
create a new xml file devAppSettings.config under a new folder myConfigsettings
If you form has Fileupload control along with other controls like dropdownlist, calendar.. you will be facing standard problem of Fileupload control losing value when other controls are selected.
I have moved my blog here..
See you there
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, the generated .pdb can be deleted very well deleted. (Because framework does not uses it)
To disable .pdb generation in Release mode, goto
Project Properties > Compile Tab > Advanced Compile Options
Goto Generate Debug Info (dropdown list) and select None.
Step 1: Create a link between two servers
Goto Query Window
EXEC sp_addlinkedserver 'PRODSVR', N'SQL Server' GO
‘PRODSVR’ is the name of the Server.Execute it.
Step 2: Setup Permission between Servers.In Management StudioGotoServer Object >> Linked Servers >>
PRODSVR (See Image)
Right Click on PRODSVR goto Properties and make changes as given below.
Step 3: To access the tables in other server
Use the following hirearchy
To access Person.Address table from AdventureWorks database
Select * From PRODSVR.AdventureWorks.Person.Address
1. Update Production server with data from development server. (SSIS is alternate way)
2. Allow users to access production database without multiple logins. (windows authentication or SQL authentication)