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 |
|
iminore
Posting Yak Master
141 Posts |
 Posted - 2007-08-09 : 06:52:25
|
| In Enterprise Manager when I right-click on an object, 'all tasks', 'generate sql script' I'm suddenly getting:'Error 1038: Cannot use empty object or column names. Use a single space if necessary'Any ideas? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-09 : 06:56:09
|
| Refresh the database - better to disconnect and reconnect.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2007-08-09 : 07:00:13
|
| I've tried that. Don't know whether it's relevant but we seem to have a database with no name listed. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-09 : 07:15:02
|
| Sounds like it's connected.Check the owners of objects.You can use the profiler to see what enterprise manager is doing and run the queries manually - you should spot something odd.I've seen odd things happen when the gui expects you to be sysadmin and gets conflicting info if you aren't.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2007-08-09 : 07:37:46
|
| Cracked it. Someone else had managed to create the 'database with no name' and when we dropped it all is well. |
|
|
|
|
|
|
generate script problem