skip to main
|
skip to sidebar
MSSQL101
Showing posts with label
CONNECT
.
Show all posts
Showing posts with label
CONNECT
.
Show all posts
Wednesday, January 23, 2013
MSSQL Connect to a database from a TSQL script
Step 1:
Switch to SQLCMD mode from the query menu in Management Studio:
Step 2:
Add the connection info using:
:Connect server_name[\instance_name] [-l timeout] [-U user_name [-P password]]
Till Next Time
Older Posts
Home
Subscribe to:
Posts (Atom)
Blog Archive
▼
2025
(3)
▼
February
(3)
SSIS Active operations
Stop running SSIS package from SSISDB
Overview of running SSIS package from SSISDB
►
2017
(4)
►
November
(2)
►
September
(2)
►
2014
(3)
►
April
(3)
►
2013
(3)
►
August
(1)
►
January
(2)
►
2010
(4)
►
November
(1)
►
August
(1)
►
June
(2)
►
2009
(6)
►
August
(1)
►
February
(2)
►
January
(3)
►
2008
(8)
►
December
(6)
►
August
(1)
►
February
(1)
About Me
John Minkjan
I'm a manager BICC at Bernhoven ZKH in the Netherlands.
View my complete profile
Labels
AGENT
(1)
ALL POSTS
(13)
BACKUP
(2)
COLUMN
(1)
CONNECT
(1)
CONVERT
(2)
CURSOR
(2)
DATE
(2)
DRIVE
(1)
DRIVES
(1)
FOREIGN KEY
(1)
FREESPACE
(1)
GRANTS
(1)
INDEX
(1)
JOBAGENT
(1)
LINKED SERVER
(2)
MSSQL
(21)
OUTPUT
(1)
Package Store
(1)
PERMISSIONS
(1)
RESTORE
(3)
ROWCOUNT
(2)
SCHEDULER
(1)
SCRIPT
(4)
SSIS
(3)
SSIS; SSISDB
(1)
SSISDB
(2)
SYNONYM
(1)
TSQL
(6)
UPDATE
(1)
VARIABLE
(1)
My Blog List
MDX101
multiple first day of week
-
Nice trick: http://richardlees.blogspot.nl/2015/08/supporting-multiple-first-day-of-week.html