Sep 9, 2013 · Put the values into a table variable (@table) and build a cursor WHILE for the logic.

Dec 16, 2014 · You can run the following T-SQL scripts to remove the associated data collector objects that were created while enabling data collector.

Jul 31, 2015 · In the following t-sql 2012 merge statement, the insert statement works but the update statement does not work. I know that is true since I looked at the results of the update statement:

Oct 4, 2011 · Now i want ot disable those 300 jobs at once by using where name like 'admin%'

Feb 28, 2008 · i had configured a merge replication betwen 2 server and i was running fine. but due to network problems my network admin has changed the ip address and name of the publisher, …

Sep 17, 2010 · Option 1 - Be sure to optimize your Database design so your application will only require at most 6 joins and used stored procs for queries using proper indexs to gain the most performance …

Jun 25, 2008 · I am using SQL 2005. As I write a procedure/function/etc, I want the Reserved Words to get converted to Capital letters (upper case) automatically. How do I set that.

Mar 9, 2012 · Question 0 Sign in to vote SELECT db_name (dbid) as DatabaseName, count (dbid) as NoOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY …

Dec 12, 2008 · It is taking your named query, using it as a nested statement within a SELECT statement it assembles which uses the 2000 t-SQL syntax. The only workaround there may be for this is to …

Mar 10, 2014 · Indeed, SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Sybase ASE version 11.9 and higher to all editions …