This any better:

WITH XMLNAMESPACES (

'www.microsoft.com/SqlServer/Dts' AS DTS

,'www.microsoft.com/sqlserver/dts/tasks/sqltask' AS SQLTask

)

SELECT

folders.foldername

,syspackages.PackageName

,c.value('../../DTS:Property[@DTS:Name="ObjectName"][1]','varchar(MAX)') ObjectName

,c.value('(@SQLTask:SqlStatementSource)[1]', 'NVARCHAR(MAX)') AS SqlStatement

FROM (SELECT...

I found this query taken from here which should get you pretty close:

https://social.msdn.microsoft.com/forums/sqlserver/en-US/7d9513e3-ea0a-45fc-be24-a7d2a56cf0dc/querying-msdbdbosysssispackages

WITH XMLNAMESPACES (

'www.microsoft.com/SqlServer/Dts' AS DTS

,'www.microsoft.com/sqlserver/dts/tasks/sqltask' AS SQLTask

...

No as we have a standard image for machines that will be used by the DB Engineering team that comes with all they will need such as BIDS, SSMS, powershell...

As mentioned already the closest you'll get using BCP is csv file format. But using another language with the appropriate plugins its not that difficult such as powershell, python,...

It shouldn't, and I know if doesn't for people in my company doing the same.

They tend to develop SSIS packages etc in BIDS but deploy and test against development...

RDS is amazons managed database solutions. So for SQL server you get a SQL instance with very limited functionality. You also cannot access a lot of the system...

Have a read of this in msdn:

https://msdn.microsoft.com/en-us/library/ms151224.aspx

This section addresses what is \ isn't possible:

Log shipping can be used in conjunction with replication, with the following behavior:

Replication does not continue after...

An approach we have adopted for one of our production systems is automated deployment via a web service.

To help put that in context our development team continually creates...

In the end we ditched the idea as we now use MySQL RDS instances in AWS rather than SQL server. We have a custom solution I designed in house...

And to address your point about the easiest way, do you have a SSRS setup? A subscribed report would be far easier that included the graph.

SQL-DBA-01 (8/5/2015)

---

Hi Experts

I have written a query to get the monthly database growth check. However, wanted to check post creating the report, can I use any script to create...

In the environments I have worked in the SQL logins used by applications have always had the same name \ permissions in each environment the only differentiation being the passwords.

I...

Very good point on the default, that totally slipped my mind.

If all you want to know is when was a row changed are you able to add a new column to the table called something like DateModified and have a...

Its going to be tricky to help refactor your code without the code to create the tables \ sample data that the query is using. Can you post up...