Right click Cubes, go to New Cube and, in the Wizard, choose "Build the cube without using a data source". Then you can generate a schema and do something...

Aha. Just found out there are still columns in my pre-aggregated tables that can be grouped and measured on.

Nevermind. @=)

I'm new to this myself, but I'll take a stab at the answer.

I don't think there is a real criteria. I think it depends on how you want your numbers...

Cursor is your best option here, then. Use the below code to get your list of database names. Use the FETCH statement against this list. Plus, add a variable that...

You don't need multiple filegroups to put files on different drives. Just multiple files themselves. They can all...

Depends on the database. We...

Neeta,

You still having this problem?

&lt blink &gt I didn't even think of that one. Thanks! I'll give it a try.

Check whichever port your endpoint uses. If it's the default (5022), check that. But there is usually 2 ports involved (ISTR) in the creation of endpoints, so make sure they...

Danb7183 (4/22/2009)The db_datawriter & db_reader gives the 'users' that are external to the domain all the rights that I believe they currently have (i.e. right to connect, add, delete, modify...

Glad I could help. @=)

Just went back to my old "Upgrading DBA skills to SQL 2005" book.

Before establishing a mirroring session, you must configure the communication mechanism through which mirroring will occur. This involves...

Ah, yes. You're absolutely correct on that. @=)

If it's an Active / Passive cluster, Steve, there won't be necessarily be multiple instances. One instance that swaps back and forth between the cluster as it fails is the...

Gift Peddie (4/21/2009)

---

You could do that but some of your intranet users will error out with Login failed and Null user errors because AD does not resolve Asp.net and SQL...