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 -> [...]
I regularly export table data from MySQL using PHP, however a question on StackOverflow.com came up where the user wanted to export data from MS SQL rather than MySQL.Handily, PHP has support for many of the same functions for MS SQL as it does for MySQL. So with a bit of reworking I was able [...]
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 [...]
A quick tip if your SSMS is slow when using the Open File or Save File Dialog Boxes…. Disconnect any Network Shares which are unreachable.
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