Tuesday, February 23, 2010

Connecting to SQL Server via Windows PowerShell with SQL Server authentication

Here is a tip from MSSQLTIPS that shows you how to connect to powershell with sql server authentication.

No comments:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...