I am in the process of writing scripts to move data from a SQL 2000 database into a different database running on SQL 2008. I had set up a linked server from the SQL 2k server to begin this process, and about 90% of the data could be moved. One of the last tables to … Read more
When using session state in an ASP.NET Web application, you have several options. If you want to store it in your application database, as opposed to the ASPstate database (created at the command line with “aspnet_regsql -S [server] -E -ssadd -sstype c -d ASPstate”), I have scripted the database objects and stored them in GitHub … Read more
By modifying the code I used for sending email attachments, I am able to execute a SQL Server stored proc and format the results as an HTML table in an email. Also, I use the sys.exit command if there are no rows returned so that the email is not sent if there is no data … Read more