Modifying sp_help_revlogin to replicate Logins
Jun 25, 2020 · We have modified sp_help_revlogin to exclude logins which are created on that server. Although such logins are scripted out but can not be created on other server. Machine …
Reference to database and/or server name in …
Mar 21, 2018 · I need the sql script which returns timezone name of the server, which should execute both in Azure sql and Sql server. (the script which i have given in question will work …
SQL Served compact 3.5 SP1 SqlCeException: The column name is …
Nov 20, 2008 · In attempting to populate a datagridview from either a Linq to SQL query, List, or bindingsource, I get a SqlCeException indicating my column name ("Used") is invalid. The …
SQL server compact and database engine
Jun 15, 2010 · I am trying to install sql express 2005. it all seems to go through fine. however when i start up there is nothing listed in the server name. here is a screen shot.
AlwaysOn AG :: SPN configuration - social.msdn.microsoft.com
Nov 7, 2018 · A Server Principal Name (SPN) must be configured in Active Directory by a domain administrator for each availability group listener name in order to enable Kerberos for the client …
Database already exists when trying to connect different …
Feb 6, 2009 · Here is what is happening. 1) I'm teaching my classmates and in the last stages we needed to develop a program that connected to a SQL Server database. At home I had to …
The SQL Server Network Interface library could not register the …
Nov 12, 2013 · The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN …
Query to pull SSRS parameter properties (Hidden, Visible, Internal)
Aug 14, 2019 · We have 1000s of SSRS reports hosted on the SQL 2008 R2. All reports are supposed to have all parameters "hidden". Random reports have been reported to expose the …
VBA Connection String for SQL Server - social.msdn.microsoft.com
May 9, 2014 · Sub ADOExcelSQLServer () ' Carl SQL Server Connection ' ' FOR THIS CODE TO WORK ' In VBE you need to go Tools References and check Microsoft Active X Data Objects …
Trigger to update another database table based on table changes
Mar 23, 2018 · Question 0 Sign in to vote I have 2 tables in different SQL server instance, here are the details: Primary table details: