Is it web based application? If yest then create SQL login with appropriate permissions and let the application access database via this login only. Let application user get authenticated on...

Please use below query to enable SA login and change SA password.

Use Master

Go

ALTER LOGIN [sa] ENABLE

go

ALTER LOGIN [sa] WITH PASSWORD=N'StrongPassword'

Go

Chandu

Check if the SA account is disabled. If it is, then enable it using below SQL query

Use Master

Go

ALTER LOGIN [sa] WITH PASSWORD='StrongPassword'

Go

Chandu

[font="Comic Sans MS"]If you dont have question,...

Exactly what is happening? What are you expecting?

Unless you have question, you wont get answer 🙂

Chandu

Andrew,

Thanks for your response.

It is SQL2008 RTM. You mean this behavour is been taken care in Service pack and this is know issue with SQLPS ???? Even this is happening...

The same can be done using sp_msforeachtable

See below script

---------------------------------------------------------------------

Create table #tmptblsize

(table_name varchar(50),

rows int,

reserved varchar(50),

actualdatasize varchar(50),

indexsize varchar(50),

unused varchar(50))

EXEC sp_MSforeachtable 'insert into #tmptblsize exec sp_spaceused ''?'''

select * from #tmptblsize

drop table...

simply remove & from the code. It will work

Chandu 🙂

you can add administrators while installation process.

Chandu

You can try with Litespeed. This is 3rd party backup tool where you can store your .bak file on any network dirve.

Chandu

Hi,

It was a problem of service pack. So we reverted that. Have you applied service pack like my case.

Please let me know the senario in detail to get the...

Hi All,

Thanks lot for your quick reply. Basically without any load SQL Server engine is taking 99% CPU. We have applied SP2 recently. For 3/4 days it was working fine....