Enabling MS SQL Extensions in WAMP

While working on a problem recently, I needed to enable the MS SQL extensions in WAMP. It turned out to be more complicated than simply hitting the checkbox in the Extensions menu… I found this great post which explained the process.. http://forum.ragezone.com/f724/get-wamp-work-mssql-673301/ The basic Idea is; Download ntwdblib.dll: HERE Click on the WAMP icon -> [...]

By |2013-01-24T17:26:00+00:00January 24th, 2013|SQL Server, Tips, WAMP, Web|0 Comments

SQL Server 2008 – Retrieving a Users’ Privileges for all tables in a databse

I recently answered a question on StackOverflow.com by a user who needed to retrieve a list of a given users Privileges for each Table in a given Database.After some trial an error I ended up with the following T-SQL Script; declare @Proc nvarchar(50)declare @RowCnt intdeclare @MaxRows intdeclare @ExecSql nvarchar(255) select @RowCnt = 1select @Proc = 'SELECT [...]

By |2017-07-24T08:33:18+01:00January 21st, 2013|Data, SQL Server, T-SQL|0 Comments

Adding SQL Server 2008 R2 features to SQL Server Express

In order to add features from the full version of SQL Server 2008 R2 to the Express version. Get a hold of the full version DVD or installation media, then use the following command from the command prompt; setup.exe /FEATURES=Tools /Q  /INDICATEPROGRESS  /ACTION=Install /INSTANCENAME=UPSTAIRSSQLEXPRESS /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITYNETWORK SERVICE"  /IACCEPTSQLSERVERLICENSETERMS

By |2015-02-25T13:47:30+00:00May 28th, 2012|SQL Server|2 Comments