Lowell (1/13/2012)

---

I wouldn't even try to restore a different server's system databases.

instead, i'd do the following:.

1. script out your jobs in the msdb database,

2. script out the logins with...

Yes.

The GDR version - 2494120?:unsure:

The refresh and all of the other control with the exception of the Show or Hide Parameter button are disabled on the preview tab.

I got the go ahead to install SP4.

Should I install the following fix?

http://support.microsoft.com/kb/2494123

I ran profiler and it list all of the state but it did not enclose each state with quotes, e.g. 'TX'.

It placed a quote to the left of the first...

Daniel Bowlin (1/11/2012)

---

Gazareth (1/11/2012)

---

Hmm, using IN @parameter works in SQL 2008, in 2005 you may need to write a function to delimit the parameter into a proper list.

e.g. I...

What do you mean by "Pick up the columns you want to create row groups on"?

Thanks for the explanation.:-)

I need to use a function but I had to switch to some DBA...

Richard Moore-400646 (1/12/2012)

---

Another thought I had was to look at the 'setup bootstrap\log' directory to see what history is out there. I believe the history is maintained, but I...

I don't recall checking that box. I just left work, I will check...

That was a good article by Steve. Thanks!

Richard Moore-400646 (1/12/2012)

---

I'd apply, SP3, CU5, then the specific security patch that you have noted. I'm not sure if the add/remove programs shows the CUs or not - you...

Thanks.:-) the KB Article is a Security patch, I assume that would I also need to apply the Cumulative Update that precedes the Security Patch?

jcrawf02 (1/11/2012)

---

Meaning that you want to be able to pick all states? (by making no selection) if so, then create your statement dynamically and only drop in the state...