So it all boils down to files ( container for temp stuff).... make sense. Thank you guys for the inputs.:-P

Thanks for your responses...

Or maybe there could be some Spool TempDB, Sorting TempDB, Tempobjects Tempdb? So they can be managed differently?

Go to the PROPERTY of the report; in the Report Definition, click EDIT, you will open an RDL file from within which you can Search For QUERY in the RDL...

rtowler1 (1/18/2013)

---

Attaching the .mdf file through the management console, without a .ldf file

1. right click "Databases" and select attach.

2. Click on "add" and select the .mdf file, click OK.

3. In...

Thanks for all the responses above.

and now that the cluster is back to shape and i would like to report back what was done.

1. Yes, the failed node was evicted...

Found this KB article from Microsoft,

http://msdn.microsoft.com/en-us/library/ms181075(v=sql.100).aspx

anyone having any issues by following the steps in there?

Thanks a lot for the pointer, Gianluca. That is quite helpful.

Looks like there is more to it.

I may reconsider if this is worth to doing it just to comply...

Just did some testings in SQL 2008 with SQL logins...

1. The user with CREATE DB permissions would be automatically granted as DB owner ( just like what the OP wants)...

Thanks guys. Here are the info

Select @@VERSION

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition...

Maybe it doesn't...

Oops, apparently i spent too much time on the previous reply and didn't see Bob's reply.

Yes, BOB is right. It is the sqllogship.exe that caused the problem. Thank you...

well, i should have waited to post this.

Just did some further more research online and found this link

http://connect.microsoft.com/SQLServer/feedback/details/559435/log-shipping-stops-working-on-clustered-instance-if-failed-over-to-another-node

This has nothing to do with the backup share folder, it has to...

How often do you do your FULL backup? or when was the last time that FULL backup was run?

Appreciate all the replies, and especially...... thank Oliiiii!!!!!!

Oliiii (4/18/2011)

---

Grant the user "Browser" on the root directory.

Accessing the properties of a report seems to first check something in the root...

Just a warning to those who would like to turn on TDE on servers that host some other databases along with the db you want to encrypt: if some of...