在非本机的服务器上用PowerShell中执行一个T-SQL查询:
C:/>PowerShell
or
C:/>SQLPS
Microsoft SQL Server PowerShell
Version 10.0.1600.22
Microsoft Corp. All rights reserved.
PS SQLSERVER:/> invoke-sqlcmd -ServerInstance dbname -Database msdb -Username "sa" -Password "sa" -Query "select top 2 * from sys.objects"
name : sysprivs
object_id : 29
principal_id :
schema_id : 4
parent_object_id : 0
type : S
type_desc : SYSTEM_TABLE
create_date : 2005-10-14 1:36:15
modify_date : 2005-10-14 1:36:15
is_ms_shipped : True
is_published : False
is_schema_published : False