Hi,

Just try follwoing usp. U will get all DB sizes in a server.

CREATE PROCEDURE Usp_FindAllDBSizes

AS

SET NOCOUNT ON

DECLARE @counter SMALLINT

DECLARE @counter1 SMALLINT ...

Good one. In recent days I heard about Hirarchial Databases. What about them? Have they released??

madhusudannaidugundapaneni

With SQL Server there is no such fecility to find what U required. I hope U can find using some third party tools like Lumigent Log Explorer.

Madhu

I have faced similar problem once in carrer.

sp_Attach function can work for some times with out log file .But it would be a best practice to retain Log file...

I believe exactly what DRB told. Using Profiler is the best way to trace the indexes usage. But there would be some performance decrease also, if U use Profiler.

madhusudannaidugundapaneni

Hi Kelley,

Thanx a lot.

madhusudannaidugundapaneni

Hi,

I think, you can find by using third party tool, like Lumigent log explorer.

Madhu.

madhusudannaidugundapaneni

Limited output is due to a value set in query connection options. Have a look into "query connection options" in query analyser, there is one option called "rowcount" to...

Hi,

I dont know anything about PERL when I was reading your article. It has given very good idea about PERL, thanks for writting this article. Could U suggest a good...

Very good article...

madhusudannaidugundapaneni

I too accept with Paul Thornett, as he told I am also getting same result as he got. I have run this on Sql2000 with service pack 2 mechine. I...

Nice article.........

In our company we are taking Full backups at weekend and diff backups in remaining days of week. We have developed automated backup system using SPs. If I'm not...

Dear Steve,

I am a DBA having 1 year of experience. In our company we have total 60gb size of 3 databases on Sql Server 7.0. Here my daily work contains..taking...