So it's practically a non-event with no impact on the SQL process. Thanks for your replies.

I work for a regional bank.

We have 30 prod instances and 6 dev/dr all on VMware. We just retired a 500gb database app that was on a blade. ...

We have a reporting system that contains nightly snapshots of our core system. These SQL databases are named with a datestamp, so each day the name of the current...

Here is a splitter TVF that returns each data value as a row in a table. It relies on some SQL XML magic.

/*

USAGE:

SELECT [Value] FROM [dbo].[split_delimited_string]

...

Well this got me to thinking - I mean this is probably a serious hack. A report query in SSRS can almost be similar to a stored proc, that...

In addition to Enable Job, there is also a check box for Enable Schedule. It is on the screen where you Edit the schedule. Perhaps the schedule got...

Oh - sorry I guess that is only for native mode. I did see a post that said that MyReports is not an available feature in SQL 2008 R2...

Connect to Reporting Services using Management Studio. Then right click on server name for Properties. You will see a check box to enable My Reports.

Have you enabled MyReports in SSRS ? It is disabled by default.

The SPID has disappeared finally. I use Hyperbac on this server. I tried stopping the Hyperbac service but it did not respond normally. So I opened up...

The SSIS Script Component would probably be the best way to go, but in my experience it is also one of the more difficult SSIS features to get a handle...

We have an 3rd party HR application that takes exactly this approach. Mainly to implement row based security in the app by joining in a table that contains the...

The way I would typically do this is to include an OR clause in my SQL query such as

AND (PROJECT = @project OR @project IS NULL)

AND (LOCATION = @location...

There is no MS office installed on prod Server. Can I still use the script task? Can you please suggest me a reference for the script task to open excel...

There is nothing native to Visual Studio that will provide additional documentation of an SSIS package. However, the dtsx file just an xml file and as such is human...