faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Thanks A Lot for the input, but I ended up having a different problem. It complains "Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option"
I did run the 'exec sp_dboption', still it doesnt work.
Is there a solution for this.
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Did you set the option to False after completing the Insert? Keeping the option on and allowing Bulk Inserts can cause Transation Log backups to fail. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.