When good copies go bad - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

When good copies go bad

Author

Topic

SamC
White Water Yakist

3467 Posts

Posted - 2003-07-14 : 06:48:11

Using EM to export a database, I get the error

"invalid column CreateDate"

Is there a log file that details what object caused this error?

Sam

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-07-14 : 07:53:47

You mean how to learn in what table this
column CreateDate is?

- Vit

SamC
White Water Yakist

3467 Posts

Posted - 2003-07-14 : 08:01:30

Yes.

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-07-14 : 08:13:18

select table_name from information_schema.columns
where column_name='CreateDate'

- Vit

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-07-14 : 08:13:22

Do a:

select * from information_schema.columns where column_name=CreateDate

and you will see which tables have such columns.

EDIT: Ouch... 4 seconds... :)

Edited by - andraax on 07/14/2003 08:13:49

SamC
White Water Yakist

3467 Posts

Posted - 2003-07-14 : 08:17:01

But perhaps it's a procedure referencing column CreateDate and a specific table is missing that column while other tables are not?

I was hoping EM might have a more specific error message somewhere.

Sam

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-07-14 : 10:07:32

It doesn't.

Try:

select * from syscomments where text like '%CreateDate%'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources