Your first method will include tables schema as well and Moreover if a table have more than 1 triggers then all of them will be scripted in 1 file only.

Looking...

Did you got any script which will generate all triggers in separate files. I have 781 triggers to be scripted out. The solution given in link does not create separate...

Did u got public role back under server roles.

In my new installation also its missing.

dlautwein (8/22/2012)

---

I have a similar problem - killed processes still rolling back more than a day later - but a linked MySQL server is involved. Some of the processes...

Does anybody got answer how to disable this?

It worked for me also..

Hi Matt

DBCC shrink and ALter didnt worked for me.

Is there any other way to reduce initial size?

This thing didnt worked for me. accidently i had put initial size of tempdb to 14000MB instaed of 1400 MB.

Now i want to decrease the size of tempdb without restarting...

I am getting below error. i am trying to generate report of policies with your code, but unable to debug below error.

Exception calling ".ctor" with "1" argument(s): "failed to connect...