Dropping and recreating procs is a regular part of our SDLC. We only ever use rename when we're going to archive off the proc. We want to make sure that...

Here's a sample path for where your SSAS database could be located. Check this and see if you can find the .cub and .dim files associated with the cube. Is...

Chris Morris-439714 (10/7/2010)

---

So, what's this all about?

INNER JOIN SOP30300

ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE AND RM20101.DOCNUMBR = SOP30300.SOPNUMBE

Are you absolutely sure that RM20101.DOCNUMBR should match to SOP30300.SOPNUMBE ? Look at...

But you don't say what type of backup you're doing. There...

Apparently it's my turn to feel snippy. I couldn't resist.

Google your error. See what you come up with. When you get confused, refer to these threads:

How to ask questions

How to post problems[/url]

How to post code questions[/url]

Brandie Tarvin (10/6/2010)

---

mbricker-600840 (10/6/2010)

---

Tom.Thomson (10/6/2010)

---

Brandie Tarvin (10/6/2010)

---

Post for the sake of bumping the post...

mbricker-600840 (10/6/2010)

---

Tom.Thomson (10/6/2010)

---

And...

Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not...

kbnyny (10/6/2010)

---

I have a query that is not pull all the data that it should be pulling. It should return 170 records. Before i added on Table SOP30300 I was...

Stefan Krzywicki (10/6/2010)

---

The main reason I want to shove him off onto his own instance of his own database on his own server is that we already have performance problems...

Stefan Krzywicki (10/6/2010)

---

Brandie Tarvin (10/6/2010)

---

Really? I haven't had any problems with it. What's your issue?

EDIT:...

Post for the sake of bumping the post #. @=)

Really? I haven't had any problems with it. What's your issue?

EDIT: Sorry. Thought you were...

Numeric instead of Integar? Bad cowboy! Doesn't he know that extra byte...