Import SQL is not working - VSTS 2008 Database Edition

The Import SQL wizard is not working when i tried to import a script into my database project.
1) When i tried importing the script that has CREATE worked fine and the stored proc was added to the database project

2) But when the same Stored Proc was modified to use ALTER while changing the procedure, it is not working.

I have attached the error message.
code.txt
cimscimsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Reza RadConsultant, TrainerCommented:
could you explain more...?
what do you mean by : use alter while changing the procedure....

explain how did you set the import in details
0
cimscimsAuthor Commented:
In the point 1, i have created a stored procedure using management studio with the keyword CREATE and save it as a sql script. In the Database project, right click and click on the Import Script and the wizard imported the newly created stored procedure into the Database project

In the point 2, I have opened the above sql script and modified the script. In the process, i have replaced the keyword CREATE by ALTER and saved the sql script. I tried to import the modifications into my database project and the wizard is showing the message that is in the attached text file in my original message.

I hope this explanation helps. Thanks
0
cimscimsAuthor Commented:
Any ideas? Urgent Please.
Thanks.
0
cimscimsAuthor Commented:
'Import Script' only allow certain statements in the database project, mostly only create statements.  There is a good explanation on this page, toward the bottom, under the heading 'Issues and Limitations'.

http://msdn.microsoft.com/en-us/library/aa833195.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.