sql server programming:
What the problem is, when you apply stored procedures the code is parsed, but
then after the proc is applied, you could drop the working tables, without
any compaints from SQL.
Now trying to reapply that proc on another database via database transfer
and it fails with the errors because it can't parse the procedure anymore.
I think that's whats happening
[quoted text, click to view] "Agnes" wrote:
> I need to import data from A To B ,There is 3 option to choose the "import
> type"
> (1) I choose option 1, all data are imported succesfully BUT there is no SP
> (2) so I choose option 3, imports all object , sp , and some scrpits
> Finally, I got an error, it said 'Failed to copy objects from Microsof sQL
> server to Micrososft SQL server"
> I presss that error and I found " invalid column.. 'column name'
>
> What happend ?? I don't where is the error . The import process is stopped
> Now.
> Please help ~~ Where I can find the error and correct it ??
>
>
> --
> ..
>
>
I need to import data from A To B ,There is 3 option to choose the "import
type"
(1) I choose option 1, all data are imported succesfully BUT there is no SP
(2) so I choose option 3, imports all object , sp , and some scrpits
Finally, I got an error, it said 'Failed to copy objects from Microsof sQL
server to Micrososft SQL server"
I presss that error and I found " invalid column.. 'column name'
What happend ?? I don't where is the error . The import process is stopped
Now.
Please help ~~ Where I can find the error and correct it ??
--
..
I got many many sp, How can i know which one got the error ?
Does there any event log / transactin log can let me know which sp or tables
got this error ?
Thanks
--
..
"Mal .mullerjannie@hotmail.com>" <<removethis> ¦b¶l¥ó
news:A49B2FAC-427F-48A2-B3BB-35EFC6637325@microsoft.com ¤¤¼¶¼g...
[quoted text, click to view] > What the problem is, when you apply stored procedures the code is parsed,
but
> then after the proc is applied, you could drop the working tables, without
> any compaints from SQL.
>
> Now trying to reapply that proc on another database via database transfer
> and it fails with the errors because it can't parse the procedure anymore.
>
> I think that's whats happening
>
> "Agnes" wrote:
>
> > I need to import data from A To B ,There is 3 option to choose the
"import
> > type"
> > (1) I choose option 1, all data are imported succesfully BUT there is no
SP
> > (2) so I choose option 3, imports all object , sp , and some scrpits
> > Finally, I got an error, it said 'Failed to copy objects from Microsof
sQL
> > server to Micrososft SQL server"
> > I presss that error and I found " invalid column.. 'column name'
> >
> > What happend ?? I don't where is the error . The import process is
stopped
> > Now.
> > Please help ~~ Where I can find the error and correct it ??
> >
> >
> > --
> > ..
> >
> >
> >
