Thanks Gail; that did the trick (rather than the SSMS interface).

ALTER DATABASE DbName

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

and then

ALTER DATABASE DbName

SET MULTI_USER

GO

Thanks,

Rob

Okay, SSMS has come back and I can access that database -- but I never got a message saying it couldn't take the database offline. Hmm. Is a...

I often find inherited SQL to be poorly formatted. Just getting things to line up helps me wrap my mind around what's going on.

My first step is to copy...

Assuming that your fields are always five characters long, would this work:

CREATE TABLE #Temp (Id int IDENTITY(1,1), PartNum varchar(5))

INSERT #Temp (PartNum) VALUES

('12345'),

('00123'),

('10000'),

('A1234'),

('12A34'),

('0A123'),

('000A1'),

('00D21'),

('00E33');

SELECT PartNum,

CASE

...

Break it down into parts. Add temporary...

Since SSRS is just generating HTML when it renders your rerport, I'd guess it's a difference in how the three browsers display the HTML. Though I wouldn't know why...

Paul Moss (11/12/2012)

---

I am have created a price list report which uses a matrix table within a list box to list product codes horizontally rather than vertically. I have run...

If you format your data sections, it makes your question a little easier to read. Is the IFCode Shortcuts on the left-hand side of your window like:

END_APOL_NO END_NUM1 END_LIMIT1...

Sorry, I'm not an AX guy, so I don't know if there's something in the product that lets you backup your security settings. I was thinking this was your...

aslorenzo (11/11/2012)

---

Hi all, is there a way to make a backup of the OLAP security roles ?

Every time we add a new field to an OLAP cube, in the roles...

mohammed moinudheen (11/11/2012)

---

sanket kokane (11/8/2012)

---

do you have copy of mssqlresource database files before the installation of service pack .

if you are lucky and you have copy of these db...

A Bing search shows that there is a project on CodePlex called CrissCross that might do what you're after.

It can be found at: http://crisscross.codeplex.com/

The description on the site says:

CrissCross is...

It sounds like the backup is corrupt; try redownloading from CodePlex.

HTH,

Rob

Let me add to the kudos; great article -- well done.

Thanks,

Rob

Katherine,

Did you ever find a solution for this?

I'm in a similar position. I wanted to test a few things in PowerPivot (Using Office 2010 32-bit) -- everything works like...