Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

    Robert Mahon-475361 (10/24/2010)


    Anytime this gets brought up (and it does, time and time again), before we argue further, I /really/ recommend reading;

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=2

    and quazibubble's posts. Yes he's argumentative, but puts...

    If you don't like how things are, change it! You're not a tree.

  • RE: Opened distributed transaction problem

    Database was not part of transactional replication. When I try to setup local publication I got a message:

    Microsoft SQL Server Management Studio is unable to access replication components because replication...

    If you don't like how things are, change it! You're not a tree.

  • RE: LOCK

    Christian Buettner-167247 (2/18/2010)


    Steve Jones - Editor (2/17/2010)


    Edited. I'll clean up points in the am.

    Sorry, but option 1 is still wrong.

    Exclusive locks prevent access to a resource by concurrent transactions

    Read access...

    If you don't like how things are, change it! You're not a tree.

  • RE: EXECUTE SQL parameters mapping problem

    Yes

    I changed syntax from SELECT to VALUES and now it works fine.

    and yes, I am working with SSIS for 3 weeks now and on moments I am enthusiastic about it,...

    If you don't like how things are, change it! You're not a tree.

  • RE: EXECUTE SQL parameters mapping problem

    No... it is one column table in SQL SERVER data type int. Value in Variable is "1" or some other number that fits int data type column...

    But I found this...

    If you don't like how things are, change it! You're not a tree.

Viewing 5 posts - 1 through 6 (of 6 total)