SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Site Related Discussions
 ummm..ban this guy?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

X002548
Not Just a Number

15586 Posts

Posted - 03/20/2012 :  02:41:33  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=74882



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 03/20/2012 :  13:51:22  Show Profile  Visit tkizer's Homepage  Reply with Quote
I locked the account, but I'm going to need Rob or Bill remove the posts via a database query as I just don't have the time to find and delete 27 of them. I did do one, lol.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 03/22/2012 :  03:34:12  Show Profile  Visit robvolk's Homepage  Reply with Quote
I just deleted another one.

Hey, I'm on vacation, alright? I'll try to fix it when I get back.
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17642 Posts

Posted - 03/22/2012 :  03:37:03  Show Profile  Reply with Quote
LOL. one at a time . . one at a time. Tag team ? so now it is Tara's turn


KH
Time is always against us

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 03/22/2012 :  11:38:24  Show Profile  Visit tkizer's Homepage  Reply with Quote
Alright, I did 5 more.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 03/25/2012 :  04:57:23  Show Profile  Reply with Quote
You need a Stored Procedure chaps ...
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 03/25/2012 :  09:07:32  Show Profile  Visit russell's Homepage  Reply with Quote
quote:
Originally posted by Kristen

You need a Stored Procedure chaps ...



Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 03/25/2012 :  13:21:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
All fixed.

If only I had SQL access to the database...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 03/25/2012 :  19:32:57  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

If only I had SQL access to the database...



Good idea! If the forum was a SQL Console then we wouldn't get so many dumb questions being asked!!
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 03/26/2012 :  12:35:39  Show Profile  Visit tkizer's Homepage  Reply with Quote
Well actually I meant Bill giving me access to it. Rob has it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4137 Posts

Posted - 03/26/2012 :  12:37:42  Show Profile  Visit graz's Homepage  Reply with Quote
:) I'll see about deleting them using SQL. Tara, do you really want access to the database? I'm happy to give it to you.

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 03/26/2012 :  12:43:34  Show Profile  Visit robvolk's Homepage  Reply with Quote
I'd give it to you in a heartbeat, I'm kinda tired of having to do all this stuff. I just think since it's still technically Bill's site (meaning he pays for the hosting) that he should make that decision.

by slow hotel connection
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 03/26/2012 :  12:52:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by graz

:) I'll see about deleting them using SQL. Tara, do you really want access to the database? I'm happy to give it to you.



I'd love minimal access, like a stored procedure that deletes all posts of a particular user. That's really all I think that I would need to do. It would be great if it were through a stored procedure so that I can't screw things up since I'm not familiar with the Snitz schema or really any forum software schema.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 07/06/2012 :  11:20:48  Show Profile  Reply with Quote
quote:
Originally posted by tkizer

quote:
Originally posted by graz

:) I'll see about deleting them using SQL. Tara, do you really want access to the database? I'm happy to give it to you.



I'd love minimal access, like a stored procedure that deletes all posts of a particular user. That's really all I think that I would need to do. It would be great if it were through a stored procedure so that I can't screw things up since I'm not familiar with the Snitz schema or really any forum software schema.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



I'm SURE that you would test out any code BEFORE you took action...just grant her dbo/sa

And give me a copy of the DDL so I can make an ERWin diagram

I Hope there is RI


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000