It says that your login has timed out ..

Internally SQL might be busy or something unusual going on internally like resource contention ..

Do one thing : restart SQL Server and...

Using 'sqlmap70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_startmail'.

Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_fileexist'

Using 'odsole70.dll' version '2000.80.2039' to execute extended stored procedure 'sp_OACreate'.

Login failed for...

Your Solution my friend :

Repro of issue :

1) Delete the Builtin/administrator account .

2) tested it through sqlcmd and got the error 18456 Level 14 State 1.

3) assume that i have...

Its good to do that .But my friend, this error is related to Virtual memory pressure and not physical memory pressure.

Even if you add 100 GB of RAM it wont...

my email is hi_abhay78@yahoo.co.in/abhay_c@hotmail.com

Regards

This error has nothing to do with RAM .This is a virtual memory pressure .

Had you been on 64 bit server you would not have got this in your entire...

I think Mark's solution should do .

Regards

Step 1 :

sp_configure 'allow updates',1

Reconfigure with override

sp_configure 'show advanced options',1

Reconfigure with override

sp_configure 'xp_cmdshell',1

Reconfigure with override

step 2:

create proc localservname

as

create table #test (rownum int identity (1,1),servname nvarchar(100))

insert into test exec xp_cmdshell 'ping...

Strange if this is happening in SQL Server 2005 .

try this even though there is nothing special i have changed .

CREATE INDEX [rerer1] ON [dbo].[MyTable]

([Name] ASC)

INCLUDE ([ID]) WITH (PAD_INDEX...

First take the database into emergency mode and then try to rebuild the index .

I think there is one more way to rebuidl the index and that is "with drop...

It looks like an issue due to hardware ((BUF_IOERR, bp->bstat)) Check the error logs from that time and see if you find error 823 there from the time near 20th.

it...

So this is what you need to do :

-> restore the system databases

-> restore the user databases

-> run the script in master for rest of the users/logins creations...

all logins , users, roles will be restored from the pervious master backup .In case you more logins/users created after the last master backup , then you need to script...

I have never tried creating the database mail profiles and accounts through Express .But for jobs you need SQL Agent .

Normal Express does nto have express agent with it .

you...

go to services >> double click the SQL Server service>>

stop the service >> type "-m" (excluding quotes) in the start parameters and click on start (do not click ok) >>...