Thanks Gail

Regards

Balaji.G

Hi,

Column Statistics for all objects

select 'update statistics' name from sysobjects where xtype='u'

now you get for all objects from your database. then you have to copy all the result...

Hi,

1. See if you perform dbcc dbreindex query. First it will drop the index and recreate it. So

...

Hi..

Or else you can import those data into excel sheet and saved in a folder. then you can export the file

into mysql database.

With thanks & Regards

Balaji.G

Hi,

We cannot move a resource database straightway right. We can change the path of this database by using property --> advanced option. then...

Hi,

If you want to see a particular database logical name. you can run this query

select * from sysfiles.

...

Hi,

Check it sysjobs,sysjobschedules, sysschedules objects in msdb database.

With thanks & regards

Balaji.G

This is for your optional,

you just restart the services. New tempdb will created automatically.

Thanks

Balaji.G

Hi,

I think its difficult to shrink the 69 gig log file. Better way if you don't want the log backup then

...

when you connect to the db server. you can use ip address instead of servername. It's an other way

to connect the database server.

Thanks & Regards

Balaji.G

Hi,

If I enable the AWE, is it true to improve the performance?

With Thanks & Regards

Balaji.G

check it, if any network issue happened.

Thanks & Regards

Balaji.G

Hi,

Check the disk space. and restore the database thru wizard wise.

Hi,

If you don't want the transaction log, Then you can use by the following query

backup log...

Hi,

If anybody connected to the database. you cannot rename the database.

First...