Error creating a table via SELECT..INSERT

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

SQL Server Administration (2000)

Error creating a table via SELECT..INSERT

Author

Topic

kowani1
Starting Member

42 Posts

Posted - 2007-03-14 : 20:36:34

Hi All,

Please help: I tried creating a temporary table(on server2)from a link server; server1, and got this error.
i.e.
SELECT *
INTO [new table]
FROM server1.dbname.dbo.[table in currrent DB/(server2)]

Error:
Server: Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object '(SYSTEM table id: -1040868738)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.

Jungle DBA

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-14 : 21:26:44

the error messages stated clearly the problem.

Check your disk space

kowani1
Starting Member

42 Posts

Posted - 2007-03-14 : 22:59:05

DOh.. I should have checked my physical disk space..

Thanks for that.

Jungle DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources