블로그 이미지
보미아빠

카테고리

보미아빠, 석이 (528)
밥벌이 (16)
싸이클 (1)
일상 (1)
Total
Today
Yesterday

달력

« » 2025.8
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

공지사항

최근에 올라온 글


Blogs from the SQL Server team SQL Azure Bloggers OPML

SQL Server Online Resources: CTP, Troubleshooting | Microsoft MSDN

#
PSS SQL Server Engineers
SharePoint Adventures : ADFS Setup – Part 1
Monday, May 16
#
Development Customer Advisory Team
Announcing SSAS Maestros v1.2
Wednesday, May 11
#
#
SQL Server Security
Integrity checks with EncryptByKey
Tuesday, Apr 5
#
PowerPivot Team Blog
PowerPivot TechCenter
Tuesday, Feb 22
#
SQL Server Manageability Team Blog
T-SQL IntelliSense enhancements in SSMS –Denali
Tuesday, Jan 4
#
SQL Server User Education
Watch new PowerPivot Videos on TechNet Wiki
Wednesday, Aug 18

Community Blogs SQL Azure Bloggers OPML

SQL Server Online Resources: CTP, Troubleshooting | Microsoft MSDN

Posted by 보미아빠
, |

요즘 사진들~

카테고리 없음 / 2011. 5. 15. 16:39

요즘 PPT 만든다고 헉 해뿌꼬....

아자씨 들이랑 공부도 하고.

존~ 술도 마시고~

사랑하는 봄양과 놀고~


Posted by 보미아빠
, |


msdtc 없이 사용하는 방법


declare @sql varchar(8000)
, @start_dt varchar(8000)
, @end_dt varchar(8000)
, @linkedserverName varchar(8000)

select @sql =''
, @start_dt = '2011-05-11'
, @end_dt = '2011-05-13'
, @linkedserverName = 'linkedservername'

set @sql = '
insert into tblx
select * from openquery ('+@linkedServerName+',
''
set nocount on
set transaction isolation level read uncommitted
declare @tblx table
(a datetime
,b varchar(100)
,c varchar(7000)
)
insert into @tblx
exec xp_readerrorlog 0, 1, '''''''', '''''''','''''+@start_dt+''''','''''+@end_dt+'''''
select * from @tblx
'')
'

exec (@sql)

Posted by 보미아빠
, |

최근에 달린 댓글

최근에 받은 트랙백

글 보관함