El poder de T-SQL (es-ES)

Samuel Lester, un senior tester en el equipo de SQL Server está escribiendo una serie de blogs acerca de cómo solucionar problemas comunes de T-SQL de diferentes maneras. Para tal efecto, cada entrada en la serie propone un problema y luego presenta algunos enfoques diferentes proporcionados por diversos contribuyentes. Hay muchas maneras de abordar un problema y…

0

The power of T-SQL

Samuel Lester, a senior tester in the SQL Server team is writting a blog series about how to solve common T-SQL problems in different ways. To that end, each entry in the series proposes a problem and then presents a few different approaches provided by different contributors. There are many ways to approach a problem…

0

SQL Server Agent job returns a failure status after success execution

I have seen this question in forums repeatedly. The job is set to copy some files over the network, the files get copied but the job status shows a failure. The reason of the failure status is that SQL Server Agent uses the exit code returned by the program to determine if the job step…

4

Enabling the Ctrl-Shift-M keyboard shortcut for template parameters in SSMS 2012

In SSMS 2012, when the known shortcut to open the window to enter the values for Template Paramenters is not enabled upon installation, the menu item Query-> “Specify Values for Template Parameters: does not have a shortcut assigned:   To enable this option, you need to go to the menu: Options -> Keyboard and change the…

1