This should solve..

USE [master]

GO

EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs'

GO

This should solve..

USE [master]

GO

EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs'

GO

I Haven't seen anywhere if the calculation the % value would take some time for SQL Server. It must be a fraction of a section for SQL Server to calculate...

Thanks Bob for your cordial welcome. (When compared to welcoming Les ;-))

There is SQL Server error log, not aware of "sql error log configuration settings...

john.arnott (11/24/2009)

---

Despite the freewheeling atmosphere, you should also be aware that some of the top practitioners of MS-SQL, including several honored by MS as "MVP"s hang out here, so...

Start to work on it and lets hope someone would come up with their brilliant idea. 🙂

I am not aware of the straight line answer.

This is only a work around / suggestion to you.

Can you use the stored procedures to generate the data and store in...

anitha.cherukuri (11/24/2009)

---

Hi Friends

I am new to SSIS 2005 .

I got 4 excel sources.I loaded the data from EXCEL into Oledb Tables.

What I am looking is

I want to truncate those 4...

Cool Script.

Deletion of database might not be the case, it must have been detached.

There is no need to run a script to find the database, you can know it from the...

I have been asking the same question.. Are you following the steps mentioned in the link given.

What errors are you getting when Altering the system databases?

Are you able to start...

Any security settings have been changed?

SQL Server is unable to access the directories that are mentioned in the error log.

Where are the changed IP address values?

The command that's required to update needs to look for the new IP details, where does it find those new IP?

I am sorry, I did not understand. Can you explain what do you mean?