are you looking to get the IP address of the client connecting to SQL Server?

I have only seen this when...

Be aware the shrink may have no effect on some log files. If the active portion of the log occupies the end of the file you may not shrink below...

this is a known issue, it's almost certainly the indexes holding the space. The data pages are not deleted just deallocated, it makes roll back...

why are you repairing, you were supposed to be adding a node on node b and selecting the existing clustered default instance?

BIDS executes under your windows user account so that will be golden 😉

Edit the data source properties in SSRS to execute in your preferred fashion (windows account, sql server account,...

either the data source does not exist or it is in another folder on the SSRS instance. In report manager select the report and go to the data source option...

hydbadrose (11/14/2010)

---

Thank you so much for your help! Can you also please send me the link or document to change to change the SQL services account password on cluster environment...

They never miss you until you're gone 😉

That's exactly what I do, any that just can't be moved for whatever reason, I consolidate to a centralised instance. Make 2...

Character set conversions! In fact Unicode and instance version may have a bigger effect, I may well be wrong...

presumably your Windows page file occupies the C drive also?

Ola's scripts are indeed great, Michelle Ufford over at SQLFool[/url] also has a great index maintenance script. Check them both out and go with whichever you prefer!

you may upload the report via the report manager website!

have you profiled the database to ascertain why data retrieval is slow?

how many rows do the tables hold when performance is slow?

what indexes have been implemented to aid data retrieval?