Hi

It seems that the SSMS thought that the new login was already created and mapped to a user that was member of db_owner group. So, when you set it to...

Hi,

Maybe you also check the current QUOTED_IDENTIFIER set in the user connection configuration.

SET QUOTED_IDENTIFIER (Transact-SQL)

https://msdn.microsoft.com/en-us/library/ms174393.aspx

Hi.

Here is a complete series of articles about how to manage and work with AG in case you did not know it.

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-1-introduction

I hope that it will give some good tips.

Hi,

Time ago I made for a customer a series of scripts that basically collected all remarkable system objects storing the results on an accessory DB and then I replicate this...

Hi,

Well It will depend on different factors like if the site is configured to absorb all users from both coasts and how many messages will cross between clients and server...

Hi,

It seems that this is a bug. This post relates almost the same issue that yours.

https://social.msdn.microsoft.com/Forums/en-US/edc4ae2d-b804-4361-94de-7482533a8084/intermittent-the-term-getdate-is-not-recognized-as-the-name-of-a-cmdlet-function-script-file?forum=winserverpowershell

Regards

Hi,

Maybe this is a long workaround but, in order to play it safe, would this workaround suitable for your issue?

1.- Stop SQL Server service.

2.- Perform a cold copy of the...

Hi,

Have you tried to force a build/version verification in the package execution option step?

I hope this helps.

Hi,

Maybe this couple of articles will help you to troubleshoot the problem:

Some known issues with SQL Server Management Studio (SSMS)

http://thesqldude.com/2012/09/13/some-known-issues-with-sql-server-management-studio-ssms/[/url]

SSMS 2012 freezes when being launched

http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/18/ssms-2012-freezes-when-being-launched.aspx

Hi,

Casually I heard just the opposite yesterday. SQL Server query engine uses additional resources to detect the use of NULLs while ANSI_NULL is set to OFF

Here is a good example...

As my colleague said SQL Server error log should give more hints.

The c0000005 error is a memory access violation error caused during service start up. Error log may point...

Hi alpenit,

Best option for you should be to perform a side-by-side migration. Basically, you have to install a new Windows OS with a SQL Server and then migrate all instance...

Just curious,

Does the DB access to a CLR stored procedures or has any network latency issues?

Hi,

FILESTREAM by design will perform better with C# or any other language that uses OS API to access to the data. As you said, T-SQL is an interpreted language but...

Hi,

Please check this KB if this case suits to your current issue even if it is a SQL Server 2008R2

https://support.microsoft.com/en-us/kb/2163980

Other troubleshoot option would be these ones

http://blogs.msdn.com/b/karthick_pk/archive/2010/11/18/sqlserver2008-script-level-upgrade-for-database-master-failed-because-upgrade-step-sqlagent100-msdb-upgrade-sql-encountered-error-574-state-0-severity-16.aspx