I am logged onto the server as the domain administrator and the domain administrator is a SQL sysadmin, however when I go to log into SSMS the only option available is the Database Engine. The reporting and integration engines are dim. I can see the reporting and integration services running. What could be causing this? This is SQL Server 2014.
SSIS and SSRS are not part of the SQL Server / SSMS install, they are a separate install after SQL called SQL Server Data Tools (SSDT). (http://blogs.msdn.com/b/ssdt/archive/2014/03/25/sql-server-data-tools-for-sql-server-2014-is-available.aspx)
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…