One of my favourites is SSMS Tools. Though it's not really for cubes or RS, it adds a lot of nice featurees to SSMS.

http://www.ssmstoolspack.com/

You might also find something interesting...

The error should tell you...

First thing I would check is if the databases with no t-log backup are in SIMPLE RECOVERY.

The short answer would be NO.

But maybe you can explain a bit more what you are trying to achieve.

Yes, varchar(1) is definitly wrong.

Also the question wasn't which datatype uses the least space, but what is best.

But how do you define best?

This shouldn't be a problem.

No need to stop/pause replication. Only if you use transactional repl with immediately updating subscribers, you won't be able to make any changes on the...

Like Gail already asked what error do you get?

You used the wrong parameter. Use /USESYSDB, /SQLUSERDBDIR and /SQLUSERDBLOGDIR.

For more info see http://msdn.microsoft.com/en-us/library/ms144259.aspx

I've chosen for nchar(1) because it only says that the value won't be NULL or empty, but there's no limitation on the characters used. Also depending on your collation sometimes...

Gaby Abed (6/4/2009)

---

And now for something completely different...

I'm visiting Amsterdam this December, staying with a sister. I'm not Dutch but was wondering what some great places to visit outside...

The code works fine on SQL 2000, but could it be that your server is using a case sensistive collation?

I noticed that the columnnames somteines use capitol letters and...

About how to add a matrix to your report see here:

http://msdn.microsoft.com/en-us/library/cc627441.aspx

and

http://msdn.microsoft.com/en-us/library/ms157334(SQL.90).aspx

About how to make a dynamic PIVOT, when you don't know3the number of columns see here:

http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx

Then use a matrix in your report. Or as I said before use a...

Look for PIVOT in Books online.

Maybe I don't understand you correctly, but wouldn't this work?

SELECT * FROM myTable

where c d