i can't answer the whole post. but if you're building clusters, remember you'll need a domain controller setup..

i recently built a sql cluster for practice but couldn't join the network...

good grief

get a good sql book

take a class

The one thing about going up against more experienced people is that they tend to want to be paid more.. I'm sure you could find a jr position somewhere, but...

just in case it'll help someone else out.. i modified your script a little:

DECLARE @newuser VARCHAR(50)

SET @newuser = 'DOMAINewuser'

SELECT 'EXEC msdb..sp_update_job @job_name = ' + '''' + sj.[name] + ''','

+...

ahh msdb has sysjobs.. thanks..

for whatever reason I was looking in master.. that doesn't make sense at all.. doh.. brain fart i guess 🙂

thanks

Michael Valentine Jones thanks.. I dont think its what I'm looking for.. I believe thats what the report comes from?.. but..

with that aside.. glad to have the link.. could be...

Hmm.. it shows a change.. but I suspect (from the user and time) that the change is from either a re-org or a rebuild

IX_v_CompanyIndex

DDL OperationTime ...

i made a comment in relation to the OP's cognitive functionality which i removed upon request.. my bad 🙂

really does irk me when I see this kind of thing though.....

ItalianOlgi (10/16/2009)

---

GSquared (10/13/2009)

---

I'd...

to be honest.. should have thought of that myself..

thanks! 🙂

edit: i see my problem now.. i was reading syslogins when i should have been looking at sql_logins.. doh!

wow.. nice thanks..

just out of interest.. how did you get this? sql profiler?

ItalianOlgi (10/8/2009)

---

Gianluca Sartori (10/8/2009)

---

Just pray that your employer doesn't come across this thread.

Good luck.

BTW, I will remember your name and never help you in these forums, because I don't think...

have you tried tracing where the poor performance is coming from when you're having the issue? Is other stuff happening at the same time? Is there a large...

You could be correct:

OP is FROM italy.. not necessarily IN italy.. bad assumption to make..

I dont really care where the OP...

worth a shot 😉