luckysql.kinda (9/15/2009)

---

Yes Silverfox,

There is a book titled "MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide Exam 70-431 (2006)". Here TABLE 1 . 3

"Developer/Standard/Enterprise Edition Requirements" says that 32...

oh mascot :-P.

if the ldf was missing, how can you lose what you never had. only uncommited perhaps but...

ok.

you have two choices.

you can either edit the job and remove the references to this database. or disable the job.

or you can run

alter database [databasename] set read_write with no_wait

which will...

luckysql.kinda (9/15/2009)

---

I am installing sql server 2005.

Silverfox, sql server enterprise edition can be installed on windows xp as well.

I am a bit concerned here with my cpu. Can anyone...

Redgate do a similar tool, not sure about the price though, in comparison.

this link might help

http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx

This link might help you as well.

http://winwebhosting.net/iis/fix-not-enough-server-storage-is-available-to-process-this-command/

got tired of re-editing my post 😀

Hmm, not sure what to suggest. there are solutions to similiar problems out there, but they are more relevant to windows xp storage issues.

like changing the PagedPoolSize on the server

or...

Sorry to disappoint you, but on XP you will only be able to install the workstation components. You need a server OS to install enterprise edition.

If your client needs enterprise...

MJ (9/14/2009)

---

Hi Experts,

I came across a small prob that when i run dbcc sqlperf(logspace).It is not showing all databases .I am having 96 databases out which 76 are only displaying...

Duplicate post

All replies please to

http://www.sqlservercentral.com/Forums/Topic787909-1291-1.aspx

http://support.microsoft.com/kb/224071

Let me know how you get on

http://www.sqlservercentral.com/Forums/Topic521288-146-1.aspx

vishal (9/15/2009)

---

hi!!

I'm facing same errors in one of our production servers. where we are taking backups in a network location which we cant change to local as per client's request....

Not exactly sure what part was unclear to be honest.

Has the job failed again? is it still an issue that needs to be looked at.

dma (9/14/2009)

---

Yeah and I'd like to understand your POV also. How is freelancing different from consulting mainly is one thing i'd love to understand more. There are various levels of...

gmamata7 (9/14/2009)

---

Hi,

We have K2 databases on SQL server 2005. I found below dump in error log. Could you please tell me what this error referring to?

2009-09-02 20:59:05.36spid2s ...