Anyway i there is something which can be used for getting the downtime, but not the duration of downtime. And that is "sp_readerrorlog". We can see the archived error log...

Ok. So i can not fetch each individual memory utilization of databases from my multiple host database server

Regards,

SAM

@ Gail : We have different applications which are running on SQL 2000, 2005 & 2008. And for each databases i wanted to check the Mem utilization of individual Dbs....

Hi Gail,

Thanks for the same.

Even our team is working on for SQL 2005 and 2008. So, it will be helpful if somebody can tell me how monitor the memory...

Here is my non Clustered Index:

Primary Key column is : [PLGID]

CREATE NONCLUSTERED INDEX [_dta_index_STOCK_5_877298235__K6_1_33_35_37_38_39_40_41_42_43_44_45_46_48_49_50_51_52_54_55_56_57_58_59_60_61_62_63_64_65_66_] ON [dbo].[STOCK]

(

[PLFTX] ASC

)

INCLUDE

(

[PLGID],

[PAQCO],

[PNARR],

[PLTRF],

[PORFY],

[PEXDT],

[PEXTM],

[PRFOR],

[PRFLN],

[PRFSL],

[PRFFY],

[PTRRE],

[PRESP],

[PTRCU],

[PTRSC],

[PTRRT],

[PERTY],

[PLHID],

[PMHID],

[PCHID],

[PETDT],

[PETTM],

[PDBCR],

[PIAMD],

[PEXVL],

[PXPDT],

[PLCVL],

[PORRV],

[POOHB],

[PNOHB],

[PRFID],

[PPLCD],

[PFRE1],

[PFRE2],

[PFRE3],

[PFRE4],

[PFRE5],

[PFRE6]

) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Hello Gail,

I do not agree that Brad will get more hate mails as this is his individual research and thought.

But speaking through the relation of nature of human...

Hi Gill,

No i have not taken the Backup of the database before i drop the table. But any way i have taken the data of that table in a temp...

Please tell me how to restore from the transaction log

Thanks & Regards,

Sashikanta Mishra!!

Thanks you guys..

Both by Temp table and CASE statement works fine for me..

Regards,

Sashikanta Mishra

It seems as there is some network problem. Try to use your Server's static IP address and not Dyamic IP address. It may connect to the server. Again check the...

Hello Gail,

Nice to see your reply.

Thanks anyway.

Regards,

Sashikanta Mishra!

Hi Gila,

But in Oracle there is a table which traces last 1000 queries fired on the same database. Can i get any kind of info from .LDF files

Thanks & Regard,

Sashikanta...