Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Migration from DB2 8.1 to SQL Server

  Hi Friends, Can we use Microsoft SSMA 6.0 to migrate DB2 version 8.1 database to SQL Server? If not…

  Divine Flame

  1 replies

  8 years, 12 months ago

  By: PHYData DBA

• Unable to start execution of step 1 (reason: Error authenticating proxy

  Dear All, I have SSIS job which I'm running through proxy but I keep receiving the following error …

  tt-615680

  3 replies

  8 years, 12 months ago

  By: tmagney

• PLEASE HELP - Cannot install 2014 with SP1 on Windows Server 2012 R2 - setup.rll ....A DLL is missing...stand alone install

  LinkID - 20476Product Name - Microsoft SQL ServerMessage Source - setup.rllMessage ID - 50000Produc…

  carlis_burns

  10 replies

  8 years, 12 months ago

  By: Sreekanth B

• DBCC CHECKDB and TEMPDB

  Hello. I am reading all that I can on the topic of speeding up DBCC CHECKDB and hearing that TEMPDB…

  SteveOC

  4 replies

  9 years ago

  By: muthukkumaran Kaliyamoorthy

• User Permission to view Only View not base tables

  Create a view involving multiple tables from mulitple schemas and gave below permission use [TEST_P…

  Rechana Rajan

  26 replies

  9 years ago

  By: Rechana Rajan

• Add article to transaction replication without generating a snapshot at all

  I have a transaction replication and the subscription was synced from snapshot years ago. Now I hav…

  jesijesijesi

  3 replies

  9 years ago

  By: andreas.kreuzberg

• AD Security Groups and Application Roles

  Good Morning All,I searched the forum and only found relevant posts from many, many years ago. …

  chris_barnhart

  2 replies

  9 years ago

  By: chris_barnhart

• Unable to pass the servername in the openquery Linkedserver

  Hi Experts Unable to  pass the servername in the @param1 variable. It just does not work. Can …

  SQL_Hunt

  10 replies

  9 years ago

  By: Lynn Pettis

• Microsoft access and sql server

  We are planning to create an access database and used linked tables to coonect to a sql server tabl…

  sqlfriend

  14 replies

  9 years ago

  By: Matt Miller (4)

• How to find who own the database mirroring endpoint

  Hello The below query will give the details of the HADR node. But I cant find who presently owns th…

  SQL_Hunt

  4 replies

  9 years ago

  By: SQL_Hunt

• View all logins and users without being securityadmin

  Hello, We are migrating to SQL 2014 and they have chosen to take away our production support team's…

  shelleybobelly

  3 replies

  9 years ago

  By: Steve Jones - SSC Editor

• Updating stats

  So i have been doing quite a bit of research on stats and trying to figure out the best way to keep…

  SQLAssAS

  1 replies

  9 years ago

  By: Adi Cohn-120898

• How many megabytes is 128 GB?

  I'm about to max out the RAM allocation on a Standard Edition of SQL Server for the first time in m…

  Gail Wanabee

  19 replies

  9 years ago

  By: SQLAssAS

• Sync login account with permission between Primary and Secondary Servers

  Hello Experts Can anyone please share with me if you had done with the syncing of login/permissions…

  SQL_Hunt

  6 replies

  9 years ago

  By: SQL_Hunt

• How to restrict access to users

  UserA is Admin he has full rights in the serverUserB is marked with Public and sysadmin in server r…

  yuvipoy

  6 replies

  9 years ago

  By: Eirikur Eiriksson