Category Archives: Database Administration
I wanted to upgrade the SQL Server 2016 installed on my laptop to service pack 1 last night. But the setup failed with this error: Final result: The patch installer has failed to update the shared features. To determine … Continue reading
Two months ago, one of my clients called me that his DB Server is not responsive. Their Server is a HP DL580 with this specs: CPU: 4 x 12 cores Memory: 256 GB Storage: 2 x Raid 10 (8 x … Continue reading
I was reported a bug in Microsoft SQL Server (all versions) that related to generate script for database permissions on August 20, 2013. Steps to Reproduce Open SSMS >> Connect to Server >> In Object Explorer expand a Sample Database … Continue reading
When speaking about Permission term in SQL SERVER , It has two parts: Server Permissions Database Permissions And from another point of view, the SQL SERVER ROLE also has two parts: Server-Level Roles Database-Level Roles In fact the Security Model of SQL SERVER is a hierarchical … Continue reading
This post comes from this MSDN Forum question. Because of use SQL SERVER Express, we cannot use Integration Services(SSIS). Therefore, we have two choices: BULK INSERT OPENROWSET(BULK…) In each statement you can insert only one column with above choices. Erland Sommarskog was … Continue reading
This query shows the Code behind of INFORMATION_SCHEMA.ROUTINE_COLUMNS.
The next script is the Code behind of the INFORMATION_SCHEMA.COLUMN_PRIVILEGES view.
Information Schema Views Code behind (INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE)!!!
Information Schema Views Code behind (INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS)!!!
Information Schema Views Code behind (INFORMATION_SCHEMA.CHECK_CONSTRAINTS)!!!