Use the sp_msforeachdb stored procedure. In the following example, I needed to find out if there were any objects that were referencing a specific linked server: DECLARE @command varchar(1000) SELECT @command = ‘USE ? SELECT OBJECT_NAME(object_id) [?] FROM sys.sql_modules WHERE definition LIKE ”%LINKEDSERVERNAME%”’ EXEC sp_msforeachdb @command In my case above, …
There are instructions out there that say to just use Web Platform Installer (Web PI) from IIS Manager to install WordPress. The problem with this is that it will install an instance of SQL Server Express on the web server. If you’re OK with that, then by all means, use …
Looking for the PHP 5.4 MSSQL Driver file (php_dblib.dll)? You can find it here. See docs.moodle.org.
Ever get the following error? Cannot resolve the collation conflict between “Latin1_General_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. I had separate databases on different servers that I needed to query off of. In my case, it was a join between a table on the local server and a table …
Here’s a method of generating a dynamic pivot of a dataset. It first generates the columns as a string (“[ColumnHeader0],[ColumnHeader1],[ColumnHeader2], …” format), builds a dynamic SQL string and executes it using the PIVOT expression. From the code below, the @cols variable is generated by using the FOR XML PATH expression. …