Sql Server SMO script functions with owner?
I have a vb 2005 program that is scripting stored procedures to a file; I can't seem to get the file to be written qualified with the owner; is there an easy way to do this. I had the SchemaQualify option set, but it doesn't seem to be helping. Any pointers?
[276 byte] By [
jayloub] at [2007-12-24]
I am using bellow Scripting Options from C# 2005 Express, and the script has owner info (though in my case all objects are owned by DBO).
scriptingOptions.AppendToFile =true;
scriptingOptions.IncludeHeaders =true;
scriptingOptions.ToFileOnly =true;
scriptingOptions.ExtendedProperties =true;
scriptingOptions.FileName ="FilePath";
you may want to post the part of the code which generates the script for review.
