Showing posts with label basic. Show all posts
Showing posts with label basic. Show all posts

Sunday, March 25, 2012

Cant allocate space for object

Hi!
I'm running mssql 6.5 and I've got a problem with a pretty basic errormessage. I've managed this scenario before, but I't doesnt seem to work this time...
The message is:

Can't allocate space for object '-482' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. (Message

What I've done so far is:
dump transaction tempdb with truncate_only
Dump master ...
I've expanded the tempdb device (alter database)

Now I'm starting to run out of ideas...
What's this '-482' (I've also got an error on -386 once)
Anybody have any idea what to do next?

Thanks!!That is the ObjectId of the table in the database.

Sunday, February 12, 2012

Cannot run apparently successful installation of SQL Server Express

I am completely new to SQL Server, and have downloaded and installed Visual Web Developer and Visual Basic Express without problems
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.

No doubt this is a very simple error or series of errors by me, but I would appreciate help.

Many thanks.

Nick

I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.

1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.

2. Alternatively, try to start it from command line by:

net start mssql$sqlexpress

|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick

Cannot run apparently successful installation of SQL Server Express

I am completely new to SQL Server, and have downloaded and installed Visual Web Developer and Visual Basic Express without problems
I have downloaded SQL Server Express and cannot figure how to start it up! SQL Server Management Studio Express CTP does nothing when I try to run it.

No doubt this is a very simple error or series of errors by me, but I would appreciate help.

Many thanks.

Nick

I am assuming you are installed it with default value, where express would be installed as instance sqlexpress.

1. Did you see express in Obj Explorer of MS Express ("<machine-name>\SQLEXPRESS") ? If so you could just right click on that node -> Start.

2. Alternatively, try to start it from command line by:

net start mssql$sqlexpress

|||Many thanks for your help Hungfu. I am trying your solutions which report back that SQLSever Express is running. I suspect my remaining problems are related to the CTP version!
Regards
Nick