In T-SQL, you'd use dateadd, with getdate() like this:

dateadd(dd, -1, getdate())

to get yesterday. In SSIS, if you are doing this, you'd use the Expression language, it's slightly different.

DATEADD("dd", -10,...

😛

I'd tend to use odbc/ado/oledb to try a connection from code and see if it works.

If you're debugging manually, copy sqlcmd.exe over there and run it.

Second vote for a table.

Strange. Just one database?

Have you tried something as simple as

backup database x to disk = 'test.bak'

and see if that works? Rebooted the Windows host?

I've never heard of this. I...

I actually think the CLR has worked well. MS used it internally to add things like HierarchyID to the native product (along with Spatial and other items). It gives them...

New laptop, and new labs for me. Toshiba Z30 arrived yesterday, so setup begins today. Then I have to make the switch from Hyper-V back to VMWare (corp decision), so...

I looked at this awhile ago, so this from memory. I don't have time to test, but I'd be sure if I were you, I put up a VM and...

Thanks, updated

I like that you're keeping a surrogate key. Good idea.

I like Lowell's thoughts on computed columns. While not specifically doing this, I have done similar things in the past and...

Thanks, I'll see if we can't clean up some of this.

isaacchk (1/15/2015)

---

Steve - I don't think I get the last sentence "just asking a business person to tell me what to do often results in neither of us being successful."...

Eric M Russell (1/15/2015)

---

My point is that the fundamental difference between relational databases versus Big Data NoSQL databases is actually not technical or even philosophical; Microsoft and Oracle have crossed...

JimAtWork (2/3/2014)

---

I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ and also do not allow the...

spaghettidba (1/15/2015)

---

Catching up after a few days away...

@steve-2:

I would buy the X5. BMWs are great cars and even old ones (mine is 6 year old) look like new. The engine...