Hi and welcome to the forums.

Next time you post a T-SQL question, please provide data in a readily consumable format, such as this:

DECLARE @sampleData TABLE (

metric_name varchar(20),

...

The column "origin_datasource_id" in the conflict table contains the "subid" column in the MSmerge_subscriptions in the distribution database.

Query the MSmerge_subscriptions table using that origin_datasource_id as a filter for subid and...

That plan is probably the best available to SQL Server to execute that query.

Please post:

1) table and index definitions

2) the exact query you are running

3) the actual execution plan...

History of backups is in msdb.dbo.backupset, backupmediaset and backupmediafamily.

Try looking in there and see what's the application name that takes those backups.

Sysadmins can be found joining sys.server_principals with sys.server_role_members.

DB_owners can be found joining sys.database_principals with sys.database_role_members.

The other permissions that allow to drop a database are CONTROL at the database level and...

Unsuccesful logon attempts are logged in SQL Server ERRORLOG. What is the login name you are seeing? Is it ANONYMOUS LOGON? Is it the correct Windows user name?

Never used it, but it looks like it can act as a standard SMTP server.

https://support.clickfunnels.com/support/solutions/articles/5000050281-using-mandrill-for-smtp-email-settings

Your question is unclear to me. This is a good place to start: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

Hugo Kornelis (2/5/2016)

---

Gianluca, how will using this stored procedure be more useful to the OP then just adding a jobstep at the end of each job to start the next...

Sorry, I edited the code.

sp_start_job does exactly what the name suggests: it starts the job, but doesn't wait for it to finish.

In this case, if you want to have a separate job to execute...

Mapped network drives are visible to the current user only. SQL Server runs as a service account that cannot see your mapped drives.

Use a UNC path instead. You won't be...

Duplicate post.

Replies here please:

http://www.sqlservercentral.com/Forums/Topic1758680-391-1.aspx

Another suggestion: don't convert datatypes if you don't absolutely need to. Those CONVERT(date,something,101) will prevent you from using indexes on the columns.

Suggestions:

1) It's a performance question, so you'd better include an execution plan in order to let people understand where the problem lies. Post the actual execution plan, not the extimated...