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 |
|
aiman
Starting Member
18 Posts |
 Posted - 2007-07-16 : 06:55:04
|
| Hi I have run this Query //////SELECT AL1.DateTime,AL1.PeripheralNumber,AL1.ANI, AL1.WorkCode,AL1.CallType,AL1.DateTime,AL1.AgentName FROM dbo.InboundWorkCode AL1 WHERE (AL1.DateTime BETWEEN {ts '2007-07-11 00:00:00.000'} AND {ts '2007-07-11 23:59:00.000'} AND AL1.CallType=0 AND AL1.TalkTime>0) ORDER BY 1, 6//////and faced this Massege from SQL Query analyser.<Could not allocate space for object '(SYSTEM table id: -635813259)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.>What can i do. Please advice me. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-16 : 08:07:14
|
| http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22502_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
Error Massage in MSQL2000