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

9 comments:

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.

Tamara Barrow 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

micheal pan said...

I just want the whole world to know about this spell caster I met
two weeks ago, wisdomspiritualtemple@gmail.com I cannot say everything he has done for me my wife
left me 3 years ago left with my kids I was going through online
when I meant this wonderful man's testimony online I decided to
give it a try and my wife is back to me now and we ar1e happily
married again cause is too much to put in writing all I can say is
thank you very much am very happy .and does alot of spell
including Love Spell
Death Spell
Money Spell
Power Spell
Success Spell
Sickness Spell
Pregnancy Spell
Marriage Spell
Job Spell
Protection Spell
Lottery Spell
Court Case Spell
Luck Spell etc. In case you need his help contact him on this email
address wisdomspiritualtemple@gmail.com he is a good man
thanks.whatsapp number +234813 648 2342

Anthony Victoria said...

How to have your husband back home with your kids again

I'm a lady with 2 kids i am from USA, my husband leave me and his 2 kids for about 10 months i go through a lot of pain i do all i could to make him returned to me and to his kids but nothing works out. it was really a stressful period to me because i could dint go through the heartbreak. i was told to get a love spell doctor contacted to help me out which i did i was lucky to get DR.PEPOKO Contact who was able to help me out, he cast up a love spell that brought back my husband to me and to his kids thanks so much DR. PEPOKO I really appreciate what you have done for me. here he his contact if you may required for it by solving your relationship email. Pepokospiritemple@gmail.com or you can call and whatssap him +2348156148821
Here is also Dr. PEPOKO website you can visit it yourself www.pepokospiritemple.blogspot.com







How to have your husband back home with your kids again

I'm a lady with 2 kids i am from USA, my husband leave me and his 2 kids for about 10 months i go through a lot of pain i do all i could to make him returned to me and to his kids but nothing works out. it was really a stressful period to me because i could dint go through the heartbreak. i was told to get a love spell doctor contacted to help me out which i did i was lucky to get DR.PEPOKO Contact who was able to help me out, he cast up a love spell that brought back my husband to me and to his kids thanks so much DR. PEPOKO I really appreciate what you have done for me. here he his contact if you may required for it by solving your relationship email. Pepokospiritemple@gmail.com or you can call and whatssap him +2348156148821
Here is also Dr. PEPOKO website you can visit it yourself www.pepokospiritemple.blogspot.com

Unknown said...

I'm 61 years old. I contracted HPV in 2011' I has be taking lot treatment for it and embarrassed some months ago the wart stated coming out seriously, I used lot recommendation because there was lot warts around my anus and was so . but today I'm totally happy I got the virus eliminated by using natural treatment from Dr voodoo herbal center after his treatment I got cured. all the warts went away' seriously believed Dr. voodoo he have the cure for human papillomavirus because he has eliminated hpv been in my body since 2011, Dr. voodoo make it possible for me. Here is Dr. voodoo email: voodoospelltemple66@gmail.com or WhatsApp him via +2348140120719 he is welled capable of curing terrible diseases.

JNECIA MCCLENTON said...

Getting rib of Herpes virus wasn't easy, I came across Dr voodoo on how he
has cured so many people from herpes and other illness so I decided to give
him a try, now am permanently cured using the natural herbs medication and
cleansing supplement sent by Dr voodoo no more herpes, contact Dr voodoo
WhatsApp number +2348140120719 also e-mail him at:
voodoospelltemple66@gmail.com

Poached Egg Recipes said...

Appreciate this bllog post