Jeff Moden (7/7/2016)

---

Tava (7/7/2016)

---

Jeff Moden (7/7/2016)

---

It comes from a computer. It can be changed. It's ok to do a temporary work...

Jeff Moden (7/7/2016)

---

It comes from a computer. It can be changed. It's ok to do a temporary work around but they...

Tava (7/6/2016)

---

Thom A (7/6/2016)

---

Would it not be a better option instead be to treat all columns coming in at the source as strings and then use a Data Conversion Transformation...

Thom A (7/6/2016)

---

Would it not be a better option instead be to treat all columns coming in at the source as strings and then use a Data Conversion Transformation Note...

Thanks for the reply, spoken with a few people and a process already built which extracts to CSV. I didn't know a process existed based on how it was being...

The step above would also be the approach I take. As mentioned by other users ensure that if it does stop it has no impact to anything within the system...

monterorf (5/17/2016)

---

Hello friends, i really hope you may help me.

I've trying to restore a db since 2 days ago and it simply can't be restored.

I've tried from the wizard...

rodto3rd (5/16/2016)

---

Currently I have inherited production, stage, qa and dev SQL environments. I am seeing what others have in place for restoring the lower environments and the schedules?

So for stage,...

Jeff Moden (5/12/2016)

---

Wouldn't it all be easier to just use a SELECT from sys.master_files? Do you really need to know things like the amount of free space and how...

Thanks for sharing that script... appreciate it

thanks for clearing all that up, appreciate it

pietlinden (5/12/2016)

---

You don't really have a new column for each day of the month, do you? If you do, that's the source of your problem.

A little normalization is a...

There are syntax errors in your code. Since the tables you provided yesterday,columns names have changed and some others have been added.

as usual ... soon as I post it, I find the solution.

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; EXEC sp_spaceused'

Is there anyway to get this into 1 table though as its across all...

Yeap, that's part of the process that should be...