Ok i will check impact on dev server then go for PRD.

Thanks

Thanks.....

yes I fired UdateUsagesand it is successfull.

is Dbcc CheckdB atomaticaly update stats or not

Thanks

Thanks,

any other features 🙂

Thanks,

can you please provide me the sample Example (Script) for same

What is the SQL server (productlevel)

check it

select Serverproperty('productlevel')

go

I think 3033 is hotfix.

hi,

I think you need to go though this http://msdn.microsoft.com/en-us/library/ms176029.aspx

i think You need to do this

1.Take the backup of table

2.drop and recreate the indexes

3.check table consistency with DBCC Checktable.

if found the same errors

1.import data from that table to new...

Hi,

What is the version of SQL server and OS ?

Hi,

I think because of you cancelled database restoration database thats why it gone in inconsistence state

find out the sql processes where which sp id uses restoration operation and...

See this:---http://www.mssqltips.com/tip.asp?tip=1688

Hi,

To transfer user use:- http://support.microsoft.com/kb/918992 script

-- like to suggest that check your application with 100 com level for test purpose it best way to find out dependency.

My SQL is the Standard Edition. and SQL is running under the Local Service Account that account by default had the Lock Pages option enabled (even though the Local Security...

1.transfer the Server logins

2.backup the database and restore it

3.check the DTS packages to migrate

4.after restoration change com.level to 100.