Disable Alert With T-SQL - social.msdn.microsoft.com
Dec 29, 2010 · In SQL Server 2005, how do you disable/enable an Alert using T-SQL? All examples I have found are using SSMS.
Convert Binary to Ascii - social.msdn.microsoft.com
Dec 12, 2006 · In this case set the field to have a data source of a T-SQL statement. In that statement, perform a select of the field you're interested in, but apply the CONVERT () or …
ssisdb query - social.msdn.microsoft.com
Dec 17, 2015 · To view the job history for a certain SQL Server Agent Job with T-SQL query, we need read permissions to view the sysjobhistory and sysjobs tables in MSDB database. To …
Modifying sp_help_revlogin to replicate Logins
Actually we need to do it through TSQL, not GUI. But you can't do that. It is a behaviour of SSMS. You can't control SSMS from T-SQL. Apart from that, was there a question on …
Reorganize Index error - social.msdn.microsoft.com
Apr 30, 2013 · Below is a small segment of the T-SQL command from the SQL server with the Reorganize Index error.
Missing SQL Collation - social.msdn.microsoft.com
Jul 7, 2015 · If the following statement returns the correct result in query window, please use the T-SQL statement “ALTER DATABASE [DBname] COLLATE Latin1_General_CI_AS” which is …
Error Restoring File - social.msdn.microsoft.com
Dec 12, 2008 · The location of the files on the live server are different to where they will be on the test machine but from my understanding of the restore t-sql i thought it the move would locate …
XML Row By Row in Sql Server - social.msdn.microsoft.com
Apr 9, 2018 · This is not possible using a normal T-SQL query, unless you do a sub query for each row, and collect the results of the subquery into a format suitable to store those multiple …
MSDB database - social.msdn.microsoft.com
Sep 24, 2010 · should sql jobs executed in MSDB database automatically or not ?