Silverfox

Forum Replies Created

Viewing 15 posts - 736 through 750 (of 1,136 total)

RE: delete trigger on table

quick answer is, eventdata is used to capture event information for DDL events and used in DDL Triggers, you want to return the command for a DML Trigger.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 15, 2009 at 12:41 am

#1053589
RE: Am I the only DBA

dma (9/14/2009)
Hi Silverfox, PASS 24 hours was not American, it was a virtual conference targeted all over the world. In fact majority attendees were from other parts of the world....
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:46 am

#1053299
RE: Am I the only DBA

Again, apologies if it came off personally. I just wanted to explore the idea a bit, not question you or your abilities. I am sorry for any ill-will.
I like you...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:36 am

#1053294
RE: xp_delete not working

timscronin (9/14/2009)
Running sql 2005 SP2 Ent edition on Active/passive cluster. I have tried several maint plans to delete backup files older than 36 hours. The files are all...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:22 am

#1053280
RE: Patches (Builds) to be applied

Jus (9/14/2009)
Hello Guys,
My Prod SQL Server box is having the follwoing version:
-------------------------------
Microsoft SQL Server 2005 - 9.00.3042.00 (X64)
Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit)...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:17 am

#1053276
RE: audit trail

shahab (9/14/2009)
I found some good post here about audit trail and even implemented one but falls short of what I want to do. I have a 3 tier application with...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:13 am

#1053275
RE: SQLBits

Jeff Moden (9/11/2009)
Zowie! I've worked for some bad companies before but never had anything quite that bad happen. Usually the aberrant manager got educated or greased long before...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:10 am

#1053273
RE: Am I the only DBA

Yeah, I have people like this around too. I don't think they count that much, so I try, hard, to ignore them. Plus, I'm pretty sure that SilverFox absolutely doesn't...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 9:08 am

#1053271
RE: Am I the only DBA

I Know I can always reply on you Grant to give me something to talk about lol. let me have a think and i will edit this post. I am...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 8:46 am

#1053257
RE: Am I the only DBA

dma (9/14/2009)
There is a ton of free training available nowadays - PASS recently ran 24 hours of PASS which was 100% free training from top notch SQL celebrities. If you...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 8:44 am

#1053252
RE: Am I the only DBA

D.Oc (9/14/2009)
Silverfox (9/14/2009)
Books and a computer would be nice, but they are a luxury not an essential. courses and certification add to your CV. they dont get you work.
what???
Books and...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 8:24 am

#1053237
RE: SSIS 2008 Script Component error

tiffanyjanetblack (9/14/2009)
I have a new 2008 pkg, added script component , wrote some
vb code and voila there was the error message when i tried to
run the pkg. I...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 8:03 am

#1053222
RE: MCTS VS DATAWAREHOSUING

I would go with what Gift has suggested, Datawarehouses are more specialised and it would be better for you to start with DBA first and then try datawarehousing if you...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 7:46 am

#1053205
RE: SSIS Packages

sureshrajan (9/14/2009)
Would like to query thru SQL on how many tasks, variables inside a SSIS Package? How to get it ?
You cannot via T-SQL, you would need to write a...
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 7:40 am

#1053201
RE: Access Linked Tables Fail

Seth Lynch (9/14/2009)
It's all my fault for locking down the server in the first place:-)
Not saying a thing 😛
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

September 14, 2009 at 7:31 am

#1053190

Viewing 15 posts - 736 through 750 (of 1,136 total)