Lynn Pettis (7/31/2015)

---

ScottPletcher (7/31/2015)

---

ZZartin (7/31/2015)

---

ben.brugman (7/31/2015)

---

Sean Lange (7/31/2015)

---

You should avoid the sp_ prefix on your procedures. It is reserved for MS and denotes it as a system procedure. The performance...

ben.brugman (7/31/2015)

---

Sean Lange (7/31/2015)

---

You should avoid the sp_ prefix on your procedures. It is reserved for MS and denotes it as a system procedure. The performance issues are mostly corrected...

Is bias inherently a bad thing?

Bird

Hmm... I guess you could a script that would do a group by on every column in every table in your database and find the duplicates, but why do you...

Hmm... on your 2014 servertry running

TRUNCATE TABLE dbo.Order__V2;

Then,

INSERT INTO dbo.Order__V2 SELECT * FROM [TestServer].[TestDB].[dbo]dbo.Order__V2;

Then,

SELECT * FROM dbo.Order__V2;

Then on your 2000 TestServer

Try running,

SELECT * FROM [TestDB].[dbo]dbo.Order__V2;

What are the...

Hmm... well if you run just the SELECT FROM linked server part of the query from the script, what are the results? Or are you getting an error message...

SSRS Newbie (7/29/2015)

---

Thank you for your response. Below is the answer to your second question:

2) That was my other question, unless there's a reason you need to do updates your...

GoofyGuy (7/29/2015)

---

Interesting....

1) if you just want something simple to get the data into you 2014 instance something like should generate the commands you need(this is assuming the database structures are exactly...

2GB is pretty tiny over all, you can probably just copy the whole thing over the linked server if it's split into small tables. It should be pretty straight...

Lynn Pettis (7/29/2015)

---

below86 (7/29/2015)

---

Lynn Pettis (7/29/2015)

---

below86 (7/29/2015)

---

Not to be to political, but people 'hired' George W. Bush because 'He was someone I could see having a beer with'. That...

Well a few questions,

1)Are you going to be transitioning entire applications at one time or will applications be running in parallel on both platforms?

2)How much data are you talking about...

Hmm... I've found that what in America in many cases is considered praise worthy for taking the initiative without explicit instructions or expressing an opinion even it differences from your...

Well datetime data types aren't stored as a string so you can't process it like a string. If you wanted to get a date range you would do something...