SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

Previous authentication no longer valid on WiFi – Cisco Aironet 1240AG

During the usage of a Cisco Aironet 1240AG there could happen that in Event Log of the access point we Read More …

SQL Server – Create Same Stored Procedure on All Databases using sp_MSForEachDB T-SQL

–> (Word) –> (PDF) –> (Epub) –> (Text) –> (XML) –> (OpenOffice) –> (XPS) This article has been published [fromdate] Read More …

SQL Server – sp_MSForEachTable Example T-SQL Code to Count all Rows in all Tables

–> (Word) –> (PDF) –> (Epub) –> (Text) –> (XML) –> (OpenOffice) –> (XPS) This article has been published [fromdate] Read More …

SQL Server 2005 – Enabling xp_cmdshell

By default, xp_cmdshell is disabled in SQL Server 2005 for security reasons.  I am currently using xp_cmdshell in my backup stored Read More …