Looks fine to me, normally I script transferable logins from the source and after attachment then run the scripts on the destination.

😎

Quick question out of curiosity, why SQL Server 2014...

Not very efficient with 7 x ( source scan -> Filter -> Compute Scalar ->...

rajemessage 14195 (10/15/2016)

---

my question was some thing else , that is with out N it is working.

now u have written N which is also good , but i am trying...

karthiknfr_1991 (10/14/2016)

---

We have access etl running on server A and B. We are going to decommission server A . There is another as400 server where we run lansa queries...

hegdesuchi (10/14/2016)

---

Hi All,

I have to update target table and I am good with below logic.

MERGE testdb.dbo.targettable r

using dbo.sourcetable s

on s.id=r.id

...

Quick guess, the GUI has SET ANSI_WARNINGS OFF while SSMS has SET ANSI_WARNINGS ON

😎

mitzyturbo (10/13/2016)

---

Exec plan attached

I'm wondering if this might be combination of using the <= operator in the inner join along with using a temp table which might be throwing the...

Can you post the actual execution plan for the query?

😎

Further on Jeff's fine reply, here is an example of "Generic" table auditing with few extras for education and entertainment.

😎

USE TEEST;

GO

SET NOCOUNT ON;

/*

--------------------------------------------------------------------------------------------------------------------------

Name: ...

How large is the dbo.sysjobhistory table in msdb? Seen similar on the same version/patch level when the table grows huge.

😎

This looks entirely wrong to me, two instances of a parameter object with the same name in the same scope, using parameters in non-parameterized code, no command is executed. My...

BLOB_EATER (10/12/2016)

---

Eirikur Eiriksson (10/12/2016)

---

BLOB_EATER (10/12/2016)

---

Hi guys, is anyone willing (and kind enough) to review a post I am doing on SQL Memory? Basically I want to talk about total vs...

BLOB_EATER (10/12/2016)

---

Hi guys, is anyone willing (and kind enough) to review a post I am doing on SQL Memory? Basically I want to talk about total vs target and show...

Quick question, what is the full output of SELECT @@VERSION

😎

Not clear what the problem is here, can you elaborate further?

😎