XML Feeds
Today I had to change the schema of a stored procedure. I couldn't find a clicky click method to do this in SQL server management studio (which kinda worries me). So I looked on google for a method and found this. But not being an SQLguru I took a few seconds to sink in.
So the syntax is.
ALTER SCHEMA nameoftheschematotransferto TRANSFER nameandschemaoftheSP
For example:
We have an SP called username.spo1 and I want to change it to dbo.spo1 so I would change it from schema username to schema dbo. This would then mean
tsql
- ALTER SCHEMA dbo TRANSFER username.spo1
The funny thing is that not even SQL prompt from Redgate recognizes the word TRANSFER as a keyword. So I guess transfering schemas is not a very common event.
Christiaan is a forensic technician who programs on the side, although my function description says that I do IT-things for 90% of the time . I'm an avid VB.NET fan and I use lots of the ALT.Net techniques, like unit-testing, nhibernate, logging, IoC, ...
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.