Monthly Archives: April 2008

SQL Server Scripts to Copy User Permission

Posted on April 28, 2008 by bardev

I have the need to copy user permissions from one user to another.   I have two SQL Server database. The structure of both database are the same.  The first db is a source database with permission for set for a … Continue reading →

Posted in SQL Server | Leave a comment

Advanced Regular Expression – Groups Name Capture LookAround

Posted on April 11, 2008 by bardev

  Zip Code Regular Expression ^([0-9]{5}-?([0-9]{4})?){1}$   I’ve been doing alot of regular expression lately and need some place to put my resources.  Below are some very good links for regular Expressions.   How to validate a valid GUID Value … Continue reading →

Posted in C# | Leave a comment

generate insert script sql server

Posted on April 4, 2008 by bardev

I’m using a backup database to do some testing.  This database already has data in it, but I would Like to add some additional data to it, possibly through a use rinterface and scripts.  If everything works well, I want … Continue reading →

Posted in SQL Server | Leave a comment