This may or may not help.

Do you have a job to Clean Up History? The Maintenance Plan Wizard has an option for Clean Up History. It will delete...

You can set a Precedence Contraint on a Control Flow Task that is based on the Failure of the Task. (I'm assuming that the task would be a Data...

I got it wrong because I over analyzed. I thought surely it can'y be this easy, Hugo wouldn't give us a cream puff. Must be getting smarter...

jeff,

I found that if you back up the transaction log after each Index Rebuild you don't have the log growing very much at all.

Steve

You will definitely need to use variables but as the previous poster indicated, there is a way to assign the value of the variables at run time from a table...

Like I said, I haven't worked with Login Triggers, but here is a thread that talks a lot about it. Evidently, if there is a problem with the trigger,...

I haven't worked with Login Triggers but why in the world would you what to allow a user to Login if the original Login failed? There are more than...

I'm really not sure but you could try it. You could also ask that question in the other thread I provided. I know there were some experts there.

What...

That is the beauty of using server side traces, you don't use profiler. Instead, you execute an sp_trace_create statement to create a trace to a trace file, execute a...

I've also downloaded 7-zip and plan to try it out using the command line interface. It supports 24 different formats including, zip, gzip, tar, rar, cab and z.

Steve

If you're looking at alternatives, you might look into a Server Side trace as mentioned in

http://www.sqlservercentral.com/Forums/Topic909777-146-1.aspx

I got one started for my Logins (and Logouts) based upon the...

Or you could Add a Precedence Constraint that on Failure branches your flow to harmless tasks.

Steve

Your Welcome.

Steve

The Microsoft Certifications for Business Intelligence Development and Maintenance (MCTS Exam 70-448 and MCTIP Exam 70-452) include Integration Services, Reporting Services and Analysis Services so Integration Services (SSIS) is just...

I'd check into converting the database to Case Insensitive (if it won't break the application). Otherwise, I would add the UPPER (or lower) function to the appropriate fields when...