Run time Configurations and Dynamic Connection String in Enterprise Library
http://blogs.msdn.com/tomholl/archive/2005/09/14/466298.aspx
Saturday, March 25, 2006
Tuesday, March 21, 2006
Batch Execute .sql files in a directory
FOR %i IN (*.sql) DO OSQL -n -U sa -P sapassword -d databasename -i %i
or Use
COPY *.SQL AllSQL.sql
OSQL -n -E -i AllSQL.sql
or Use
COPY *.SQL AllSQL.sql
OSQL -n -E -i AllSQL.sql
Friday, January 20, 2006
Potential causes of the SQL Server does not exist or access denied error message
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306
Not able to open PDF in Browser
Resolution:
1. Get the latest Acrobat Reader
2. Uncheck Display PDF in browser box in Acrobat Reader in client m/c
1. Get the latest Acrobat Reader
2. Uncheck Display PDF in browser box in Acrobat Reader in client m/c
Wednesday, January 18, 2006
Internal Server Error (500) for Exceptions, SoapExceptions in XML Web Services in Internet explorer
Resolution : IE-> Tools->Internet Options->Adavanced->Browsing->Show friendly Http Error Messages - UnCheck that box.
Thursday, January 12, 2006
SQL Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 71 - XML parsing error: An Invalid character was found in text content
Issue in SQL Server :
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 71XML parsing error: An Invalid character was found in text content.
Resolution :
Change the parameter as Text/CHAR/VARCHAR to NText/NCHAR/NVARCHAR
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 71XML parsing error: An Invalid character was found in text content.
Resolution :
Change the parameter as Text/CHAR/VARCHAR to NText/NCHAR/NVARCHAR
Sunday, January 08, 2006
Subscribe to:
Posts (Atom)