$connString = "Data Source=192.192.192.192\SQL2008,1433;Initial Catalog=FollowMeTest;User Id=Логин; Password=Пароль;"
$SqlConnection = new-object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = $connString
$SqlCmd = New-Object System.Data.SqlClient.SqlComman
$SqlCmd.CommandText = "dbo.AppUser"
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$DataSet.Tables[0]

ALTER PROCEDURE [dbo].[AppUser] 
	@Login varchar(50), 
	@Имя varchar(30), 
	@Фамилия varchar(30), 
	@DepartmentID int = 3, 
	@EmailAddress varchar(30) 
AS
BEGIN
	set nocount on
IF EXISTS ( SElECT* FROM dbo.Users
WHERE [UserLogon]=@login OR
[EmailAddress]=@EmailAddress)
	BEGIN
	     Raiserror ('Такой Login или Email уже есть',16,1)
	     return 0		 	
	END
INSERT [dbo].[Users]
([UserLogon]  , UserFirstName , UserLastName, DepartmentID, [EmailAddress])
VALUES
(@Login , @Имя , @Фамилия , @DepartmentID, @EmailAddress)
RETURN (SELECT userID FROM dbo.Users WHERE userLogon = @Login AND UserFirstName = @Имя AND UserLastName = @Фамилия AND DepartmentID=@DepartmentID AND EmailAddress = @EmailAddress) 
END

$connString = "Data Source=192.168.5.43\SQL2008,1433;Initial Catalog=FollowMeTest;User Id=Roman; Password=Roman2;"
$SqlConnection = new-object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = $connString
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "[AppUser]"
$SqlCmd.CommandType = [System.Data.CommandType]::StoredProcedure
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlCmd.Parameters.AddWithValue("@Login", [System.Data.SqldbType]::VarChar)
$SqlCmd.Parameters.AddWithValue("@Name",  [System.Data.SqldbType]::VarChar) 
$SqlCmd.Parameters.AddWithValue("@Lastname",  [System.Data.SqldbType]::VarChar)
$SqlCmd.Parameters.AddWithValue("@EmailAddress", [System.Data.SqldbType]::VarChar)
$SqlCmd.Parameters["@Login"].Value="Test"
$SqlCmd.Parameters["@Name"].Value="Test"
$SqlCmd.Parameters["@Lastname"].Value="Test"
$SqlCmd.Parameters["@EmailAddress"].Value="Test"
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$DataSet.Tables[0]