checkai (11/12/2008)

---

We currently run in an environment that includes SQL Server 2000, 2005 and 2008. I'm looking for an easy to use monitoring tool that will be able to help...

Sorry mate. That is not possible. You will either need to create a new instance or rip-out the old one and start again. There maybe functionality in SQL 2008 but...

Hmmm, not reaslly sure mate.

The maintenance plans are .dtsx package solutions so i suppose in theory you could automate some sort of cloning process.... To be honest I'm not to...

madhu.arda (11/11/2008)

---

Thanks

1.D,E,F of Node1 can visible in Node3 and are not accessible? CORRECT. BUT THEY SHOULD NOT SHOW

2.G,H,I of Node3 can visible in Node1 and are not accessible? CORRECT....

Mandhu,

Is this the same infrastructure / servers we were talking about the other day? If so I dont really get where the 7 instances came from.

If your Node 1...

No, not as far as I am aware of. The Maintenance Plan view allows you to create the plan via task objects and their relationships, etc.

Once your done it...

:w00t:

Hi there,

Ok, you have a large number of questions so I will answer in point form:

•Having the reporting databases (Sharepoint$ReportServer/TempDB and K2$ReportServer/TempDB) on the SharePoint and K2 server respectively is...

I used this recently, it worked great for me and gave me just what i needed. It has to be customised for each database and must be run from SSMS...

Gotcha!

Sorry misunderstood your requirements. Just in the middle of something but take a look at these.

http://www.odetocode.com/articles/299.aspx

http://www.devx.com/dbzone/Article/28165/1954

PIVOT tables may hold the key 😉

Here I figured that you may have a 'Sales' table which holds details on the sales and a sale is then related to a job or multiple jobs where there...

I havent played with views too much so there may be an easier way of doing this but i would suggest putting a filter statement on the view you already...

Yeah. Strange huh!

ahhh, ok scratch that last comment, hadnt seen you response.

Sounds stupid and im grasping at straws now but are they both defined in the same way in services.

I have...

I'm being told that the 'Local Security Policies' has to be set so the account is in the 'Login as service' group, though not sure if this does or can...

I work in a very heavily security concious environment and at one point found that although services.msc had said the account had been given logon-as-service rights did not actually make...