I never had this issue before, but I recently joined new company and this issue of slow connection to the remote SQL Server 2012 from my laptop SSMS showed up....

They do not provide anything or our company decide not to buy extra packages at this time. But, my question is, if a server is at the cloud does it...

Thank you for responding. We are not at Windows Azure, this is private cloud hosted at Dallas called iLand. Does it make any difference?

I just happen to receive the same error.

In my SSIS code, I had script task and I set the result to failure inside my C# code, when a variable...

In my experience, I never thought of temporary stored procedure at all. I have scripts stored my local project folders tones of them. I only create stored procedure, when I...

This is a known issue with SSMS, many DBA struggling to answer database owners with this question. Only way to resolve this issue is to avoid using SSMS for this...

I started this question while ago, I am glad everyone contributing to it and I appreciate everyone's opinion and view.

When writing TSQL, it is not matter of we struggle to...

It make sense. Now, I don't use Symmetric Key and I just use Certificate and Encrypt/DecryptByCert function help me to achieve what I want. I know this is not optimal...

Thank you all.

Not at all...It is just a trigger and fires every time when user logs in.

Believe me, if you are Operational DBA or Production DBA, you need this to track...

This will help you to understand what is server wide log in audit..

Link 1)

Linke 2)

You can control the user by host name, application and more...

I Google my self on the...

1) Create a server side trigger to monitor the login for this user account and check which machine they use this log in ID to come to the server. If...

Think of a subroutine as a function but this function resides at the same procedure, not outside of the procedure. For example, if you call a function from a stored...

Sub routines are not stored procedures or functions. Subroutines can reside in the same stored procedure or function or in ad-hoc TSQL scripts. Normally, this is achieved by TSQL GOTO...

Try this and more on Google as well...

http://www.codeproject.com/KB/aspnet/VBnet_Methods.aspx