Okay. Makes sense. That would put it at 12:30...

Curious, Yahoo currently says our draft is Wednesday August 27th at 2:00 PM, what time zone is that?

Steve Jones - SSC Editor (7/21/2014)

---

Julie Breutzmann (7/21/2014)

---

Welcome back! My pastor just got back from a renewal leave of four weeks and it made a huge impact on her. Unfortunately,...

Eirikur Eiriksson (7/21/2014)

---

Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods, there are...

ChrisM@home (7/21/2014)

---

Lynn Pettis (7/21/2014)

---

Just a thought, but I was wondering if the following would work:

SELECT WorkOrder, TakTime

INTO

[plc].[TaktTime]

from openquery([SAPETL],'

WITH TaktValues ([Counter], NODE, PLNNR) AS

(

...

Just a thought, but I was wondering if the following would work:

SELECT WorkOrder, TakTime

INTO

[plc].[TaktTime]

from openquery([SAPETL],'

WITH TaktValues ([Counter], NODE, PLNNR) AS

(

SELECT...

Issues.

One, you only posted the DDL for one synonym, but enough on that.

Two, it is looking like the "tables" may actually be views not actual tables.

Three, and I may be...

Still confused. Are you saying that...

So you are saying the Linked Server is hidden by using a synonym? Well, not obvious from what you posted. What is...

Welsh Corgi (7/21/2014)

---

Hi Tom the script that provided me still works.

USE tempdb;

GO

-- TRUNCATE TABLE dbo.Name_and_SSN

-- DROP TABLE dbo.Name_and_SSN

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

CLEAR_SSN VARCHAR(12));

--point_ctl.agent_support.tax_id_number

--and point_cyp same table

INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)

VALUES

...

How do you see CheckDB running? Do you see it when running Activity Monitor?

Last time I checked CheckDB does not run on its own, it has to be invoked...

Just signed up. Looking forward to another year!

That is really just a suggestion. The OP can...

Assuming this process is run once a day and you want current day plus last 90 days, give this a try:

declare @BatchSize int = 10000,

...

Ed Wagner (7/18/2014)

---

Lynn Pettis (7/18/2014)

---

SQLRNNR (7/18/2014)

---

Sean Lange (7/18/2014)

---

SQLRNNR (7/18/2014)

---

Did you see somebody push him in the...