Asp.NET Tips

"System.Security.SecurityException was unhandled" error appears during creation of CDO.Message object. CDO.Message msgTemp = new CDO.MessageClass(); The error above happens when I tried to run windows forms application from the network drive (default VS projects locations). This was solved only by moving whole project to the my local drive.

The simple way to run T-SQL script from batch file is using SQLCMD command. It's can be useful to run repeatable tasks like backups or restores. Basic syntax is: C:\Windows> sqlcmd -S SERVERNAME -o "OUTPUT_FILE.TXT" -U sa -P PASWORD -i C:\MySCRIPT.sql Following article have more detailed information: Using the SQLCMD command line utility for SQL SERVER

In case you need to update or insert specific data to SQL Server identity column use following syntax: SET IDENTITY_INSERT tablename ON INSERT statement SET IDENTITY_INSERT tablename OFF