Viewing 15 posts - 3,451 through 3,465 (of 7,168 total)
XACT_ABORT may work, but I would recommend you use TRY/CATCH instead for managing exceptions and transactions.
BEGIN TRY;
BEGIN TRAN;
Exec StoredProc1; -- this stored...
August 1, 2012 at 11:34 pm
SpringTownDBA (8/1/2012)
Ola hollengren, DB maint script.Don't reinvent the wheel.
+1
August 1, 2012 at 10:51 pm
An Execute Process Task could work as well. I have done similar things by building my command line arguments dynamically in a variable using an Expression and then mapping the...
August 1, 2012 at 10:47 pm
Tatsu (8/1/2012)
August 1, 2012 at 10:30 pm
The EAV model is an anti-pattern when attempts are made to apply it as a 'more flexible' replacement to a proper relational design. There are certainly places where it shines,...
August 1, 2012 at 10:01 pm
It's a least common denominator approach. If SSMS were coded to account for every permutation possible to arrive at the most efficient way to add a column think about the...
August 1, 2012 at 9:38 pm
SQLRNNR (8/1/2012)
L' Eomot Inversé (8/1/2012)
EL Jerry (8/1/2012)
Revenant (8/1/2012)
crookj (8/1/2012)
L' Eomot Inversé (8/1/2012)
Cliff Jones (8/1/2012)
L' Eomot Inversé (8/1/2012)
bcsims 90437 (8/1/2012)
SQLRNNR (8/1/2012)
Cliff Jones (8/1/2012)
JAZZ Master (8/1/2012)
L' Eomot Inversé (8/1/2012)
Daniel Bowlin (8/1/2012)
ChrisM@Work (8/1/2012)
opc.three...
August 1, 2012 at 6:40 pm
Giving Permissions through Stored Procedures by Erland Sommarskog
Look for sentence beginning with "As you might guess."
August 1, 2012 at 4:21 pm
@matt-2, there's no check-out process. That sounds like a pretty good way to track objects that you've worked on!
It is a critical point, and is the crux of what is...
August 1, 2012 at 1:04 pm
SQLSACT (7/31/2012)
pooyan_pdm (7/31/2012)
August 1, 2012 at 11:38 am
August 1, 2012 at 11:31 am
Time to do some homework.
Documentation: Conditional Split Transformation - SQL Server 2005
And here is a visual example of Conditional Split:
Handling NULL Values in SSIS Using The Conditional Split Transformation
August 1, 2012 at 11:29 am
Don't forget to remove any log shipping work done to this point:
How to: Remove a Secondary Database (Transact-SQL) - SQL Server 2005
August 1, 2012 at 11:22 am
eg61088 (8/1/2012)
Two words: got it.😉
Fantastic! You might be surprised how many database development shops do not 'have it' and do not 'get it' as to why it is critical....
August 1, 2012 at 11:17 am
sys.objects - SQL Server 2008 R2
object_id is a column in the sys.objects catalog view and uniquely identifies an object in the current database. In other words the object_id for a...
August 1, 2012 at 11:05 am
Viewing 15 posts - 3,451 through 3,465 (of 7,168 total)