Thank U.

Hey Lutz,

The script you mentioned is for different purpose. It is similar to sp_help /to know the structure of a table!!!! 😉

Thank you.

Thanks

Planning to upgrade OS to 2003 Server.

Thanks 🙂

Thank You

Answer to myself... 🙂

--Solution

alter table emp WITH CHECK CHECK constraint fk_emp_deptno;

Thank You so much.

Thank You So much.

It work Fine 😀

Hi,

Can i know the reason why you are dividing by 128 in the first SELECT query

1. Script that will display space utilization detail at data file level:

use <DBName>

GO

select convert(numeric(10,2),round(a.size/128.,2))...

Thanks masters!

Thanks! 🙂

Thanks Arun.

Its been long time i heard from you 🙂

Hi,

I myself i tried to do some coding and come up with a stored procedure which would delete the previous backups.

Am putting this for the benefit for all...