If you are not aware of the SP sp_readerrorlog or xp_readerrorlog..Please learn about them since there are option to read previous logs and also search for particular string combination inside...

Try some more methods...

1) You can specify np: infront of your server name when connecting to SQL Server to forcibly use Named Pipes as Protocol. Check whether it is working...

2)...

Hi all,

I just remember something like... there is some session variable which we can check using trigger each time a table is modified so that we can...

Hi,

Go to Component Services and check whether MSDTC is running. Make sure that it is running with NetworkService account. Run profiler in the destination server and see...

Gr8.. So you will be sharing you experiences after completing this experiment?

Hi Ranjit,

There is no simple method to resolve your problem... Try this...

1. Split you SP Queries into individual blocks

2. For each block (You can name it...

Hi,

Please check my previous reply... I have attached there...

Hi All,

1) SQlInv.dll is missing in the article.. I'm attaching it here.. I will try to upload it to article... (Please rename .txt to .dll)

2) Also regarding OLAPServer Inventory question......

Ok my next ball...

Can you run scheduled profiler for Transactions/sec on each database and check over a period whether there are some transactions happening in DB?

I thought you would have enabled this as corporate standards... If not then try this... Monitor the growth of the database over period by running some scheduled jobs and if...

Will auditing output suit your requirement? You can check the SQL Server Error log for the user login activity and if there is no user login then there is no...

AFAIK, Solution for Table Scan is to create proper Indexes... Try atleast to create indexes in the columns which are of most use in your query...

Hi,

This will scan analysis services too... Please scan any one IP where analysis services is installed and check the output and let this forum know how it...

Hi,

You can check for my article on Enumerating SQL Instances throughout your LAN which is getting published on Sep 4. For this requirement you can use this...

Hi Steve,

It is happening when opening SSMS when inside server itself... But If you restart SQL Instance the functionality will be normal and in due course it...