![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mssql
promotelife
这个作者很懒,什么都没留下…
展开
-
mssql get jobstate by name
DECLARE @job_state INT Exec msdb..sp_get_jobstate_byname 'job_name',@job_state out select @job_state ---------------- use msdb go create procedure dbo.sp_get_jobstate_byname原创 2014-06-26 13:15:16 · 478 阅读 · 0 评论 -
WITH EXECUTE AS [user]
The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "BIData" under the current security context.原创 2014-07-21 15:52:50 · 1193 阅读 · 0 评论 -
Bulk copy failed user does not have alter table permission
The fquestion is whether the triggers and constraints should be fired or not. If so, specifying FIRE_TRIGGERS and CHECK_CONSTRAINTS would prevent the need to alter the table. (The ALTER is disablin转载 2014-07-10 14:53:18 · 880 阅读 · 0 评论