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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-08-26 : 03:20:41
|
| Hi All,I am usign this query i am getting this error:use tempdbxp_readerrorlogCREATE TABLE #ErrorLog(Logdate datetime,Processinfo varchar(15),ttext varchar(1000))insert into #ErrorLog select master..xp_readerrorlogPlease help me |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-08-26 : 03:30:33
|
| Msg 4104, Level 16, State 1, Line 1The multi-part identifier "master..xp_readerrorlog" could not be bound.Msg 213, Level 16, State 1, Line 1Insert Error: Column name or number of supplied values does not match table definition. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-26 : 11:34:28
|
it should beinsert into #ErrorLog exec master..xp_readerrorlog ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Query error