| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-03-22 : 03:34:12
|
I just deleted another one.  Hey, I'm on vacation, alright? I'll try to fix it when I get back. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-22 : 03:37:03
|
LOL. one at a time . . one at a time. Tag team ? so now it is Tara's turn 
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-03-25 : 04:57:23
|
| You need a Stored Procedure chaps ... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-25 : 09:07:32
|
quote:
Originally posted by Kristen
You need a Stored Procedure chaps ...
 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-03-25 : 19:32:57
|
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!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2012-03-26 : 12:37:42
|
| :) 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. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-03-26 : 12:43:34
|
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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-03-26 : 12:52:36
|
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2012-07-06 : 11:20:48
|
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://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/saAnd give me a copy of the DDL so I can make an ERWin diagramI Hope there is RI |
|
|
|
|
ummm..ban this guy?
Tara Kizer