Thanks a lot SQL Masters! 🙂

I appreciate it much!

With your suggestions, i do have now an idea for this DR Plan.:-)

Thanks a lot Masters!

Cheers,

Tsinelas

Hello Guys,

Thanks for the replies... i appreciate it much!:-D

Hi John,

Thank you very much!! 🙂 I made this one. 🙂

Create table #DInfo([DDrive] nChar(1) Null, [MB_Free] Float Null)

Insert #DInfo EXEC master..xp_fixeddrives

DECLARE @vDBName nVarchar(200)

DECLARE...

Hi Master SSC Journeyman,

Just asking if you guys have an idea on how to pull records of database information on SQL 2000, as of now on sql 2005 and 2008...

Master Sam Pinto,

Salamat sa reply 🙂

Gusto ko sana makita ung filegroup total size in MB and filegroup free space in MB ng Databases kasama na rin ung file location via...

Hi SQL Masters,

Thank you very much! for your responses, i appreciate it much 🙂

Thank you and Best Regards,

Tsinelas

Hi SQL Masters,

Thank you all for your response. It works fine now 😀

Best Regards,

Dev1

Hi,

The firewall is off and no antivirus installed on this virtual machine. regarding exchange server, i only used smtp.gmail.com

Thanks,

dev1

Hi,

Is the script applicable on SQL Server 2000, 2005 ?

Thanks

dev1

Hello,

Thanks for the response. 🙂 I understand now. 🙂

Thank you and Best Regards,

Dev1

Hi,

Thanks for the quick response 🙂 i appreciate it much 🙂

-dev1.bohol

Thanks everyone 😀 I learned from you all.

-dev1.bohol

Hi,

Thanks for advise, it works on me :-D, regarding your question, it's nothing, i just want to try to execute some scripts on command line 😀

Thank you

-dev1.bohol

Hi,

The script T-SQL you privided is good, but you can just use the dbcc inputbuffer(SPID#) only once you have identified the blocked process and blocked by process.

By running the command...

You are welcome my friend 🙂

Cheers!

-dev1.bohol@gmail.com