- 博客(6)
- 资源 (1)
- 收藏
- 关注
转载 sp_send_dbmail fails when query uses linked server
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4e6e8c6c-3cc6-4988-a60c-74e3b2b542f7/spsenddbmail-fails-when-query-uses-linked-server?forum=sqldatabaseengine 这是一个bug
2013-12-20 16:47:35 1147
原创 Session blocked itself
When an SPID is waiting for an I/O page latch, you may notice that the blocked column briefly reports that the SPID is blocking itself. This behavior is a side effect of the way that latches are use
2013-12-13 16:47:18 773
转载 wrong @@SERVERNAME
http://msdn.microsoft.com/en-us/library/aa933172(v=sql.80).aspx
2013-12-12 17:10:35 955
转载 SQL server linked server 权限配置页面
http://technet.microsoft.com/en-us/library/ms188477(v=sql.105).aspx 需要注意的是里面很多权限选项只针对SQL Server 权限认证,windows认证不可以。
2013-12-12 10:19:01 2285
转载 Deadlock troubleshooting
http://blogs.msdn.com/b/bartd/archive/2006/09/08/deadlock-troubleshooting_2c00_-part-1.aspx http://blogs.msdn.com/b/bartd/archive/2006/09/13/751343.aspx http://blogs.msdn.com/b/bartd/archive/200
2013-12-10 16:41:51 1133
转载 SQL Server 2008 - How to convert GMT(UTC) datetime to local datetime?
declare @InputUtcDateTime datetime2 = '2013-12-10 03:43:50' declare @LocalDateTime datetime2 = dateadd(minute, datepart(TZoffset, sysdatetimeoffset()), @InputUtcDateTime) print @LocalDateTime
2013-12-10 11:48:22 1307
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人