i cuoldnt make work with out making the user in the administrator group on the PC running SQL server, this is not right there should be a solution am still...

the account is a domain account and its not expired i rechecked it.

i will the log on the quriom.

this are some of the errors and the list go long, i check every error log u have said and found nothing.

-Cannot drop the procedure '##zDP_2263009SI', because it does not...

thats was on the edge but its good to see that u passed the exam when the result just pop out on the screen.

am still preparing for the test but...

hello all.

have they added simulation to the test or not yet?

am planning to take the test in the next 2 weeks, hope to get it.

am testing the modificaton it takes at least 3 hours..

there is no standered for this it dependes on several facter, i can think off some like the database size, number of users, transactions activity on the db, the recovery...

so if i found mofcomp in the windows files i can still ues it, right..

i have no file like mofcomp in the path C:\Program Files\Microsoft SQL Server\90\Shared?

of course u can, i have found some on the site u just search for auditing triggers.

but u might need to adjust the scripts a littel bit.

ok thanks alot for help..:)

thats good, but lets get back to the main question,

if i have a cluster server, then how can i change the sql port?

just change the port and every thing will...

thats really sucks.

so if i dont want to call microsoft then i would never know what cosed the crash!!

any one ones how can i open SQLDump0032.mdmp ??

hay iv got the same problem today and my production server went dead.

any one how to find what event or statment triggered the stack dump?:w00t: