Archive of posts tagged 2000

Superfast Powershell Script Gets SQL Server Log Utilization

Posted by on

This is a nifty Powershell script which uses DBCC sqlperf(logspace) to get the log utilization for all your databases on all your servers. Best of all, it is super quick! I have over a dozen servers from 2000 to 20008 with numerous databases on each. This routine returns all my log information in a matter …

Continue reading ‘Superfast Powershell Script Gets SQL Server Log Utilization’ »

Share

Linked Server 64bit Deficiency

Posted by on

First off, I need to give recognition to Joel Mansford for his blog which gave me the answer to my problem. Connecting SQL Server 2005 x64 to SQL Server 7 (32bit) as a linked server!? After creating a linked server on a 64bit SQL Server 2005 instance, I then needed to create a view which …

Continue reading ‘Linked Server 64bit Deficiency’ »

Share