Sorry! my bad.

Small correction in Case 3: b)

b. if the first record itself C1 ! = C2 then keep 1 as for C3 column in the ouput.

All the comparisons...

Thank You Gila!:-)

Hi Roshan,

Below is the ouput of the two commands

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Database Mail XPs'

GO

nameminimum maximum config_value run_value

Database Mail XPs011 1

EXECUTE msdb.dbo.sysmail_help_account_sp

--no output --

Is there any...

Hi,

Thanks for the script.

But i am working in SQL Server 2000 environment!

Moreover, Assuming that the backup folder is not shared.

On the same server, nothing is in share , the job is running and unable to trace which other process is accessing...

Hi,

The solution was superb.

Do you have similar kind of thing through which we check from command line i.e dos prompt. or else does this information is stored/ archived or...

Go through the below link

http://www.sqlservercentral.com/Forums/Topic806297-146-1.aspx

Hope it helps you!

Hi,

I dont have required permissions to restart the sql server in single user mode. That is not allowed. Is there any other alternative method through which i should be able...

Hi All,

I am able to generate the scripts dynamically. just i need the code which can execute the generated sql inside the stored procedure.

The login has all the required permissions...

Hi All,

I have allocated enough space and the problem was resolved.

Thanks all.

Hi,

I want to keep track of all the autogrowths of a particular database in sql server table , how can we do that?

Thank You.

I will allocate sufficient space in the beginig and kick off the script!

Thanks once again!

I tried to investigate the issue.

Tried at my local end.

Temp.mdf initial size 10m , autogrwth = 10% , maxsize =20m

Temp.ldf intital size 1m, autogrowth=10% , unrestricted growth

now, i...

Hi Manu,

Basically, i have created the database using windows authentication and dettached the database once after pumping some data in.

And when i tried to attach, i could find any...

If you take a look at the below sequence of taking and backup,verifying and deleting the previous day backup, "EDFUSION" is the last database which is getting deleted.

I also filtered...