Viewing 15 posts - 106 through 120 (of 486 total)
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...
September 2, 2015 at 3:03 am
I found this query taken from here which should get you pretty close:
WITH XMLNAMESPACES (
'www.microsoft.com/SqlServer/Dts' AS DTS
,'www.microsoft.com/sqlserver/dts/tasks/sqltask' AS SQLTask
...
September 1, 2015 at 4:52 am
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...
August 31, 2015 at 9:03 am
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,...
August 31, 2015 at 8:38 am
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...
August 31, 2015 at 8:35 am
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...
August 17, 2015 at 4:23 am
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...
August 11, 2015 at 3:42 am
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...
August 11, 2015 at 3:26 am
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...
August 10, 2015 at 7:24 am
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.
August 6, 2015 at 4:46 am
SQL-DBA-01 (8/5/2015)
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...
August 6, 2015 at 4:37 am
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...
August 3, 2015 at 9:25 am
Very good point on the default, that totally slipped my mind.
July 14, 2015 at 7:31 am
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...
July 14, 2015 at 5:49 am
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...
July 9, 2015 at 6:50 am
Viewing 15 posts - 106 through 120 (of 486 total)