Thanks Grant..

Then what is the common process for database size tracking?

We do have a monitor tool which collect file utilization based on each file.

But i want to make one consolidate...

Hi,

It depends on the purpose what you use the information for.

I want to track my database backup file growth based on the backup information collected..

Hey sorry for the type I mean sql 2012

Hi Good Morning,

Can anyone share some details on what are the things to consider or aware like a checklist to migrate from...

Hello,

I noticed the job is running perfectly awesome as it did before 2 weeks.

I havent changed anything except reorganize indexes job ran over the weekend.

But i am not sure what...

Hi,

This is what i am getting when i try to collect execution plan.

The query has exceeded the maximum number of result sets that can be displayed in the Execution Plan...

hi grant,

The same sp is running on another 6 different servers and performance on everyone of them is very good.

I cant understand why this is acting so weird on this...

Hi,

thanks for your reply

yes the db is in full recovery and log backups job is running succesfully for every hour.

we have clustered and non-clustered indexes on tables and there are...

Thanks for the reply and I really appreciate that.

your post helped me a lot..

but there are only default trace files after the sql server has started but not of the...

THANKS FOR THE POST..YA IT LOOKS FINE AND NEED TO LOOK AT YOUR IDEAS TOO

ABOUT THE TRIGGER AND DB MIRR.

I guess database mirroring is not possible, my report db is on differrent server. I need my report database to be always in synch with up to time data with...

Thanks for the answer suresh that helped me a lot.

Thanks Bru,

I want know if we disable remote connections on a sql server we cant be able to access sql server from remote machines and apllication will not be able...

Hi ..

You can use the following vb script to start the sql service automatically..

*********************************************************************

VBS Script: By Service Name

strComputer = InputBox ("Enter Machine Name")

objServiceName = "Service_Name"

Set objWMIService =...

Hi sejal...

Thanks for the info...

I am not able to figure it out can u plz provide in detail how to run the file on multiple servers

Thanks Bru,

It was very helpful to me..for getting the default value made a small change.

declare @NumErrorLogs int

exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', @NumErrorLogs OUTPUT

print @NumErrorLogs

Thanks.......