Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rum23
Yak Posting Veteran
77 Posts |
Posted - 2009-04-01 : 11:38:04
|
Hi, I am using the proc_generate_excel_with_columns stored procedure created by Madhavan but I get the error on executing it. Can you please help? Thanks muchEXEC proc_generate_excel_with_columns 'databasename', 'tablename','Cfilename'ErrorMsg 208, Level 16, State 1, Procedure proc_generate_excel_with_columns, Line 11Invalid object name 'information_schema.columns'. |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-02 : 05:04:55
|
quote: Originally posted by rum23 Hi, I am using the proc_generate_excel_with_columns stored procedure created by Madhavan but I get the error on executing it. Can you please help? Thanks muchEXEC proc_generate_excel_with_columns 'databasename', 'tablename','Cfilename'ErrorMsg 208, Level 16, State 1, Procedure proc_generate_excel_with_columns, Line 11Invalid object name 'information_schema.columns'.
Try capitalising itINFORMATION_SCHEMA.COLUMNSMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
|