• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

SQL Compact 2008 Problem creating a stored Procedure


I am having a problem creating a stored procedure as shown by the error in the following image

Murray Brown
Murray Brown
2 Solutions
Olaf DoschkeSoftware DeveloperCommented:
SQL CE does not support stored procs at all.
Aaron TomoskyTechnology ConsultantCommented:
Compact doesn't support most t-SQL. If you need something standalone chek out the SQL 2012 localdb. Same commandset at full SQL but only one connection.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thank you very much for the help

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now