An issue created through the use of Transparent Data Encryption (TDE)
To sandbox a set of databases for a specific application a named instance was created on the SQL server. 448 more words
Without manual intervention, one level of INSERT…EXECUTE is the limit
An INSERT EXEC statement cannot be nested.
It is telling you is that you can’t have a proc that does an INSERT-EXEC operation call another proc that also does an INSERT-EXEC operation. 74 more words
Quick one today:
Sometimes we all need to write/execute stored procedures manually in SSMS. When stored procedures have OUTPUT parameters, the execution is slightly different (counter intuitive). 187 more words
Today I stumbled upon this little annoying issue.
If you are trying to run a stored procedure using OPENROWSET, for example:
SELECT * 240 more words
FROM OPENROWSET('SQLNCLI','Server=(LOCAL);Trusted_Connection=Yes;Database=DB_Name','EXEC .dbo.SP_Name')