摘要：
The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system. ---- To all... 阅读全文
摘要：
CREATE PROC getBusinessLineHistoryASBEGIN SELECT * FROM sys.databasesENDGOsp_configure 'Show Advanced Options', 1GORECONFIGUREGOsp_configure 'Ad Hoc Distributed Queries', 1GORECONFIGUREGOSELECT ... 阅读全文
摘要：
1. Configure sql mail Double click Database Mail in Management node in SSMS, set up new e-mail profile and specify its smtp account and relevancy 2. After configuration, execute script below. us... 阅读全文
摘要：
sp_msforeachdb 'select ''?'' as DBName, count(*) as ObjectCount from ?.sys.objects' sp_msforeachtable 'select ''?'', count(*) from?' sp_msforeachtable 'update statistics ?' 阅读全文
摘要：
We can use OBJECT_ID function to check whether the object exists in SQL Server db, for example, we can do some safety check, if exists, ignore the creation procedure. 1. Check the sp exists -- Sa... 阅读全文
摘要：
Question: When running at Debug mode, the Debug.Assert(…) method should pop up a modal dialog by default, and this could stop current running. Solution: 1. All set to Release mode for source code, ... 阅读全文
摘要：
Characters to Avoid in Directories and Filenames http://www.mtu.edu/umc/services/web/resources/cms/characters-to-avoid.html Do not use any of these common illegal characters: ... 阅读全文
摘要：
I got several questions asking what is the best way to run SSIS packages programmatically. One question is about running SSIS from a .NET 1.1 application (SSIS uses .NET 2.0). Another about running pa... 阅读全文
摘要：
Problem One of the Junior SQL Server Developers in my company approached me yesterday with a dilemma. He was developing an SSIS Package which imports data from a comma separated text file and he... 阅读全文
摘要：
This step-by-step article describes how to spawn a process that runs under the context of the impersonated user in Microsoft ASP.NET pages. To spawn a process that runs under the context of the impers... 阅读全文