Wednesday, November 16, 2011

Quickly disable triggers and keys


/* run before importing data */
-- SQL disable all triggers - disable all triggers sql server - t sql disable trigger
EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL"
GO
-- SQL disable all constraints - disable all constraints sql server
EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO
/* deletes all existing data */
-- SQL disable all constraints - disable all constraints sql server
EXEC sp_MSforeachtable @command1="DELETE FROM ? "
GO

/* run after importing data */
-- SQL enable all triggers - enable all triggers sql server - t sql enable trigger
EXEC sp_MSforeachtable @command1="ALTER TABLE ? ENABLE TRIGGER ALL"
GO
-- SQL enable all constraints - enable all constraints sql server
-- sp_MSforeachtable is an undocumented system stored procedure
EXEC sp_MSforeachtable @command1="ALTER TABLE ? CHECK CONSTRAINT ALL"
GO

5 comments:

Unknown said...


Am here to testify what this great spell caster done for me. i never believe in spell casting, until when i was was tempted to try it. i and my husband have been having a lot of problem living together, he will always not make me happy because he have fallen in love with another lady outside our relationship, i tried my best to make sure that my husband leave this woman but the more i talk to him the more he makes me fell sad, so my marriage is now leading to divorce because he no longer gives me attention. so with all this pain and agony, i decided to contact this spell caster to see if things can work out between me and my husband again. this spell caster who was a woman told me that my husband is really under a great spell that he have been charm by some magic, so she told me that she was going to make all things normal back. she did the spell on my husband and after 5 days my husband changed completely he even apologize with the way he treated me that he was not him self, i really thank this woman her name is Dr Aluta she have bring back my husband back to me i want you all to contact her who are having any problem related to marriage issue and relationship problem she will solve it for you. her email is traditionalspellhospital@gmail.com she is a woman and she is great. wish you good time.
He cast spells for different purposes like
(1) If you want your ex back.
(2) if you always have bad dream
(3) You want to be promoted in your office.
(4) You want women/men to run after you.
(5) If you want a child.
(6) You want to be rich.
(7) You want to tie your husband/wife to be yours forever.
(8) If you need financial assistance.
(9) HIV/AIDS CURE
(10) is the only answer to that your problem of winning the lottery

Contact him today on: traditionalspellhospital@gmail.com

Queen Kc said...

When I found Dr. Paul I was in desperate need of bringing my ex lover back. He left me for another woman. It happened so fast and I had no say in the situation at all. He just dumped me after 3 years with no explanation. I contact Dr.Paul through his website and He told me me what i need to do before he can help me and i did what he told me to, after i provided what he wanted, he cast a love spell to help us get back together. Shortly after he did his spell, my boyfriend started texting me again and felt horrible for what he just put me through. He said that I was the most important person in his life and he knows that now. We moved in together and he was more open to me than before and then he started spending more time with me than before. Ever since Dr. Paul helped me, my partner is very stable, faithful and closer to me than before. I highly recommends Dr. Paul to anyone in need of help. Email: astoriashrine@ gmail com, Call him or add him on whatsapp via: +2349051441669

lara clear said...

How I Got My Ex Husband Back..Am so excited to share my testimony of a real spell caster who brought my husband back to me. My husband and I have been married for about 6 years now. We were happily married with two kids, a boy and a girl. 3 months ago, I started to notice some strange behavior from him and a few weeks later I found out that my husband is seeing someone else. He started coming home late from work, he hardly care about me or the kids anymore, Sometimes he goes out and doesn't even come back home for about 2-3 days. I did all I could to rectify this problem but all to no avail. I became very worried and needed help. As I was browsing through the internet one day, I came across a website that suggested that Dr Aluya can help solve marital problems, restore broken relationships and so on. So, I felt I should give him a try. I contacted him and and told him my problems and he told me what to do and i did it and he did a spell for me. 48 hours later, my husband came to me and apologized for the wrongs he did and promise never to do it again. Ever since then, everything has returned back to normal. I and my family are living together happily again.. All thanks to Dr Aluya Powerful Love Spell that really works. If you have any problem contact him and i guarantee you that he will help you. He will not disappoint you. Email him at: aluya.48hoursspelltemple@gmail.com. or whatsapp him on: +2348055431163.

lara clear said...

How I Got My Ex Husband Back..Am so excited to share my testimony of a real spell caster who brought my husband back to me. My husband and I have been married for about 6 years now. We were happily married with two kids, a boy and a girl. 3 months ago, I started to notice some strange behavior from him and a few weeks later I found out that my husband is seeing someone else. He started coming home late from work, he hardly care about me or the kids anymore, Sometimes he goes out and doesn't even come back home for about 2-3 days. I did all I could to rectify this problem but all to no avail. I became very worried and needed help. As I was browsing through the internet one day, I came across a website that suggested that Dr Aluya can help solve marital problems, restore broken relationships and so on. So, I felt I should give him a try. I contacted him and and told him my problems and he told me what to do and i did it and he did a spell for me. 48 hours later, my husband came to me and apologized for the wrongs he did and promise never to do it again. Ever since then, everything has returned back to normal. I and my family are living together happily again.. All thanks to Dr Aluya Powerful Love Spell that really works. If you have any problem contact him and i guarantee you that he will help you. He will not disappoint you. Email him at: aluya.48hoursspelltemple@gmail.com. or whatsapp him on: +2348055431163.

Voodoo home said...

i want to share my wonderful testimony on how i got back the love of my life.he left me to another woman for no reason and i try to make things work for both of us,yet things where getting worse. I was almost losing hope in life when my lover of 4 years ended our relationship without any reason and I went for help in the internet and all I met was fake spell casters and scams and I consulted an old friend of mine and explain my situation to her and she said she was in same situation 2weeks back but a wonderful man who was sent to help people helped him out of the problem and I thought it was all a joke and I ask her if it was real and she said if it wasn’t real so how did her lover come back to her, then I decided to give Dr voodoo a try because I had nothing to loose in trying i met a testimony again share by Marina from Iceland on the internet talking about a powerful spell caster who brought his ex lover back within 48 hours and to my greatest surprise he also did it for me just as he did to my friend and Marina and others people. and i have a lot of people complaining of fake spell caster but this one i met was a real spell caster and genuine and there is nothing like been with the man you love from heart am so happy my love is back to me with the help of Dr voodoo. His contact details voodoospelltemple66@gmail.com or Add him on whatsApp +2348140120719