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 |
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
 Posted - 2007-11-16 : 14:36:19
|
| I have a table on my database, sheet1$, created when someone imported an Excel spreadsheet, now I can't get rid of. It apparently doesn't even exist! Any suggestions on how to get of this phantom?Thanks,Jim |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-11-16 : 14:37:21
|
| drop table [ownername].[sheet$]CODO ERGO SUM |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-11-16 : 17:48:48
|
| I tried that and I get an invalid object message. I can't even select from it!Jim |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-11-16 : 17:54:38
|
| You can't select from it, you can't drop it, and SQL Server says it isn't there.What makes you think the table actually exists?CODO ERGO SUM |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-11-16 : 18:12:37
|
| My loose grip on reality needs for it to exist to convince myself I am no longer hallucinating.I am not the sa on the server (we just switched from an environment where everybody was sa) but I still get to deal with these wierdnessesThanks,Jimcogito esse ergo esse |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 01:18:07
|
| Are you dbo? If not, ask dba to fix it. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-17 : 08:31:43
|
Try refreshing your object browser. The name in the table list will probably no longer be there.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-11-18 : 17:19:32
|
| rmiao,I was dbo then I wasn't for a while (without being told that) and now I am again! We recently switched to an HA cluster (without testing or warning, we just came in on Monday, and there it was). In the old environment just about everybody was sa, then nobody could do anything, and now I'm sure we're on our way to everybody being sa again. Can I nominate my boss for the twit list? Our production db is the same as our reporting db and development db. We spend most of our time putting out fires. At least I have successfully dropped the table.Thanks for all your helpJim |
|
|
|
|
|
|
|
|
sheet1$