Apparently there are some problems with Service Pack 1 and SSIS. Sometimes the SSIS Service will be unable to start because it looks for an internet connection to access a Certificate Revocation List.
Lucky us, there is a solution... check out this post.
Wednesday, April 26, 2006
Monday, April 24, 2006
SQL Server 2005 Books Online (April 2006)
Another update of the books online here to go with Service Pack 1.
On a side note, Internet Explorer 7 Beta 2 has been released too.
Also find the readiness kit here.
On a side note, Internet Explorer 7 Beta 2 has been released too.
Also find the readiness kit here.
Sunday, April 23, 2006
Deferred constraint checking?
Greg Low has a nice suggestion imho.
Basically the idea is the following (from ADO.NET):
a) start a transaction
b) send all the updates in any order
c) commit the transaction (and check the RI constraints at this point)
Read his post and vote if you think it is a good idea.
Basically the idea is the following (from ADO.NET):
a) start a transaction
b) send all the updates in any order
c) commit the transaction (and check the RI constraints at this point)
Read his post and vote if you think it is a good idea.
Subscribe to:
Posts (Atom)