peterswe (8/12/2013)

---

Our outsourcing partner is trying to setup a way to start SSIS jobs from BMC Control-M. There seams to be a problem doing that because the SSIS job returns...

Bakhesh (8/12/2013)

---

Thanks for the response. Normally, I'd agree, but we are seeing significant improvements working with temp tables (something I usually avoid like the plague). I think I have a...

madferdy2009 (8/12/2013)

---

Good morning

I needed to make a stored procedure for maintaining a database SQLServer 2008. The idea is to automate the deletion of records in the tables and load table...

ChrisM@Work (8/12/2013)

---

Jeff Moden (8/10/2013)

---

Brandie Tarvin (8/2/2013)

---

How many people (besides Jeff and myself) have written SQL Spackle articles?

How many SQL Spackle articles are there?

Yes, I have a reason for asking. But...

Brandie Tarvin (8/12/2013)

---

Jeff Moden (8/10/2013)

---

Brandie Tarvin (8/2/2013)

---

How many people (besides Jeff and myself) have written SQL Spackle articles?

How many SQL Spackle articles are there?

Yes, I have a reason for asking....

Sean Lange (8/9/2013)

---

wolfkillj (8/9/2013)

---

Sean Lange (8/9/2013)

---

Ed Wagner (8/9/2013)

---

Stefan Krzywicki (8/9/2013)

---

For me the investment is getting something that I won't have to spend much on during its lifetime. I drove my...

Sean Lange (8/9/2013)

---

Ed Wagner (8/9/2013)

---

Stefan Krzywicki (8/9/2013)

---

For me the investment is getting something that I won't have to spend much on during its lifetime. I drove my Pathfinder 276,000 miles...

paul.knibbs (8/9/2013)

---

It's definitely documented (which I wish I'd read before answering the question incorrectly):

http://technet.microsoft.com/en-us/library/ms177562.aspx

See...

I figured the answer had something to do with the effect of using non-determinative functions and the NULLIF(), because if I stripped away the ISNULL() and ran this:

SELECT NULLIF(CONVERT(varchar, SIGN(CHECKSUM(NEWID()))),...

Perhaps a silly question, but did you install a default instance? IIRC, you can install a named instance without first installing a default instance. If you only ran the install...

Only that...

L' Eomot Inversé (8/6/2013)

---

Series of 5 books by Susan Cooper, called "The Dark is Rising", which is also the title of the second book in the series (the first was...

I have a question that has been nagging at me for a while, and I think the probability that someone on this thread will know the answer exceeds the probability...

tdanley (8/2/2013)

---

Thanks this worked great! WOLFILLJ

wolfkillj (7/30/2013)

---

tdanley (7/29/2013)

---

I have a sales report that shows the previous days sales. I need to modify to a rolling report that shows the...

sandosh.star (8/1/2013)

---

how to trigger a job after completion of another job in sql server management studio 2005

I have two JOBS A and B in JOB Activity monitor

I want to trigger...