Results 1 to 3 of 3

Thread: [Microsoft][ODBC SQL Server Driver]Syntax error or access violation'

  1. 04-25-2003, 02:54 AM #1
    arun
    arun is offline Registered User
    Join Date
    Apr 2003
    Posts
    9

    [Microsoft][ODBC SQL Server Driver]Syntax error or access violation'

    Where i try to create stored procedure in sql server 2000 using query analyzer i'm getting an error

    '[Microsoft][ODBC SQL Server Driver]Syntax error or access violation'

    and the same stored procedure if i try after some time without any changes it gets created..

    how is wrong?
    Reply With Quote Reply With Quote
  2. 04-25-2003, 08:48 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Got permission on the db to create sp? Also check mdac version on your pc.
    Reply With Quote Reply With Quote
  3. 04-25-2003, 09:23 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    What SP you have on that?

    Install latest service pack on that machine again.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules