mssql notes - Revision history

Nighthawk at 17:53, 25 May 2021

2021-05-25T17:53:08Z

2021-05-25T17:52:46Z

2021-05-17T13:24:07Z

2021-05-17T13:21:42Z

2020-09-08T16:52:31Z

2020-09-08T03:54:11Z

‎command examples

2020-08-22T12:53:25Z

‎command examples

2020-08-22T12:52:36Z

2020-08-22T12:49:45Z

‎links

2020-08-22T12:35:16Z

@@ Line 21: / Line 21: @@
 same as above but parsed from command line for easier reading...
-sqlcmd -S 192.168.1.1 -U SA -P ******** -Q "SELECT * FROM ''myDB''.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTable_of_interest' " | sed 's/ \+/ /g' | grep -v "\-\-\-"
+ $ sqlcmd -S 192.168.1.1 -U SA -P ******** -Q "SELECT * FROM ''myDB''.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTable_of_interest' " | sed 's/ \+/ /g' | grep -v "\-\-\-"
 *** note - replace *192.168.1.1, *******, myDB and myTable_of_interest with your parameters

@@ Line 18: / Line 18: @@
 show all columns and schema for a table
 > SELECT * FROM myDB.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTable_of_interest'
 ==other stuff==

@@ Line 12: / Line 12: @@
   SELECT * FROM <myDBname>.INFORMATION_SCHEMA.TABLES;
   GO
 show all columns and schema for a table
 > SELECT * FROM myDB.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTable_of_interest'
 ==other stuff==

@@ Line 12: / Line 12: @@
   SELECT * FROM <myDBname>.INFORMATION_SCHEMA.TABLES;
   GO
 where <myDBanme> is replaced with DB name of interest

@@ Line 42: / Line 42: @@
      setup-ad-keytab   Create a keytab for SQL Server to use to authenticate AD
                        users
 ==links==

@@ Line 4: / Line 4: @@
 change sa password
   ALTER LOGIN [sa] WITH PASSWORD=N'abc123'
 show list of all tables

@@ Line 33: / Line 33: @@
 ==links==
 [https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-troubleshooting-guide?view=sql-server-ver15 Troubleshoot SQL Server on Linux]
 [https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent?view=sql-server-ver15 Install SQL Server Agent on Linux] - agent runs scheduled jobs
 [https://support.microsoft.com/en-us/help/965049/how-to-set-up-a-microsoft-sql-server-odbc-data-source How To Set up a Microsoft SQL Server ODBC Data Source]

@@ Line 31: / Line 31: @@
                        users
+==links==
+[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-troubleshooting-guide?view=sql-server-ver15 Troubleshoot SQL Server on Linux]
 [[category:database]]
 [[category:mssql]]