jasona.work (4/18/2016)

---

Couple...

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific libraries in script components...

shamshad.ali (4/18/2016)

---

Ids could be deleted so they won't match from random generated numbers, I need something like existing Ids only to be shuffled.

Tried following and it only uses the random...

Steve Jones - SSC Editor (4/18/2016)

---

BWFC (4/15/2016)

---

Steve Jones - SSC Editor (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Wouldn't mind...

Brandie Tarvin (4/18/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Brandie Tarvin (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Further on Luis's good advice, change

USE MyWorkplace;

GO

to

USE master;

GO

otherwise you'll get the error

Msg 3702, Level 16, State 3, Line 6

Cannot...

Quick suggestion, add default values to the new columns

😎

,NEW_COL INT NOT NULL DEFAULT(0)

Quick suggestion

😎

USE Test;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.VNEWID') IS NULL

BEGIN

DECLARE @CREATE_VIEW NVARCHAR(MAX) = N'

CREATE VIEW dbo.VNEWID

...

djmenon21 (4/17/2016)

---

Try to write the simplest query that fully answers the question, avoiding unnecessary complexity.

These tables from our data warehouse provide enough information to answer (you may not need all...

jharris215 (4/15/2016)

---

I have trying everything, Perstaging the SQL Network name with the right permissions and I'm still this error Log Name: System

Source: ...

Phil Parkin (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Phil Parkin (4/15/2016)

---

GilaMonster (4/15/2016)

---

I'm going to have to steal "Don't have...

Sean Lange (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Ed Wagner (4/15/2016)

---

Greg Edwards-268690 (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix...

Phil Parkin (4/15/2016)

---

GilaMonster (4/15/2016)

---

I'm going to have to steal "Don't have a clue how to...

Ed Wagner (4/15/2016)

---

Greg Edwards-268690 (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix in three steps

1. Drop...

Greg Edwards-268690 (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix in three steps

1. Drop procedure

2. Drop...

Brandie Tarvin (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

jeff.mason (4/15/2016)

---

Eirikur Eiriksson (4/15/2016)

---

Quick fix in three steps

1. Drop procedure

2. Drop...