December 2005 - Posts

9
Comments

Change schema name on Tables and Stored procedures in SQL Server 2005 by steve schofield

I was trying to change the 'schema' name on an object from 'username' to 'dbo' in SQL Server 2005. The script generates code you have to copy, paste and run on the database. Thanks to the DBA gurus on the sql-sqlsvr-sprocs@sqladvice.com list that provided...
Filed under:
0
Comments

Create Export & Encrypt connection string on server and dev machine with ASP.Net 2.0 by steve schofield

This article covers some basic steps and commands to encrypt your connection string and other items in a configuration file using ASP.NET 2.0. Microsoft has made it much easier to have a portable key that encrypts certain sections in a web.config that...
More Posts