Home Forums Article Discussions Article Discussions by Author Discuss content posted by Namwar Rizvi Quickly Generate Random number by TSQL with 99.9% Uniqueness Guarntee RE: Quickly Generate Random number by TSQL with 99.9% Uniqueness Guarntee

  • September 17, 2009 at 8:49 am

    #1055027

    I was not able to run the script. I pasted use temdb as first line. I am using SQL Server Management studio 2008 as client and SQL server 2005 as server.

    following are the errors that i was getting

    Msg 102, Level 15, State 1, Line 10

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Line 11

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Line 13

    Incorrect syntax near ')'.

    Msg 102, Level 15, State 1, Line 17

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Line 22

    Incorrect syntax near '?'.

    Msg 208, Level 16, State 1, Line 5

    Invalid object name 'tblTest'.

    Msg 3701, Level 11, State 5, Line 3

    Cannot drop the table 'tblTest', because it does not exist or you do not have permission.