Did you restart SQL Server? According to this BOL Article the new name is recognized at SQL server startup.

First thing to look at is the log_reuse_wait_desc in sys.databases. Then you can look at DBCC OPENTRAN() or query the sys.dm_tran_% DMV's to see what the transaction is.

As a...

DM definitely has a trace that runs on a...

You aren't going to be able to use a standard SSIS Flat File Source for this, you are going to have to do scripting to read the file row-by-row. ...

I recommend you read the series of posts on XQuery by Jason Strate found here, http://www.jasonstrate.com/tag/xquery/. He does a better job explaining it than I can, but, briefly, .value...

The first one is dynamic sql and where the parameters have a default value of empty string ('') you need to change it to '''' (four single quotes) because the...

Evil Kraig F (11/18/2014)

---

*stares at 3 pages of spammers*

Steve... can you convince the powers that be to put up a 'board of shame' or something on these spammers? Stick...

There are several tools out there from RedGate, Idera, Dell (formerly Quest), and I'm sure others. The third-party tools usually have more compression options and also often include encryption...

You can also look in sys.dm_exec_sessions and the transaction_isolation_level column to find out if the devs know what they are doing. Here's the mapping from BOL:

0 = Unspecified

1 =...

In order to "upwards" cascade parameters you'd have to load all the values for every parameter into the report to start and then do the filtering on the reporting server...

A variable can only hold one result so all this:

DECLARE @N VARCHAR(MAX)

SELECT @N = [Name] FROM [dbo].[database_tags]

Is returning is the Name from the first row it...

I know it can be done because I believe both PragmaticWorks BIExpress and Myst by Varigence allow you to inject code into existing SSIS packages. I'd recommend looking into...

I don't think that there's a number that anyone can give you. You have to be wary about adding suggested indexes. I like to at least do the...

If you are an employee you probably have something in your employment agreement that states that the company owns the code you write on their time and/or their equipment. ...

Is the static data for each of the 6 sections the same regardless of the package?