I have deployed a SSIS package on my sql server 2012 integration service. its in my production environment and to execute the package I do not see the option of right clicking on the package and executing it. i was told that if i can get the GUID of the package (which I did) there is a command that i can run using the guid from the query window . can someone please let me know what that command is.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…