Thanks Joe, I come from an App dev background, and even though I've been writing SQL code for 8 years old habits are hard to get rid off. 🙂

I managed to figure out a more dynamic way of doing this using a couple of recursive CTE's one to traverse downt he hierarchy the second to traverse up the...

Changing the Instance name is a standard approach when installing multiple versins, if only to tell them apart.

As for the Account I meant is it using the Local...

you might want to check the Event logs on the PC to see the reason behind the failure, it might give you more insight.

What account is the SQL server service...

Thanks Dave, much appreciated.

Gianluca Sartori (2/25/2011)

---

Not true: operations on table variables are logged, but don't...

In my opinion a Table varialbe is great for very small data sets (1 or two columns, and less than 100 rows), any more than that and you should consider...

Sky,

seem your manager is non-tehnical and doesnt really understand the importance of the tempdb.

No Problem, It sometimes helps to have a second pair of eyes look at a problem. :crazy:

It seems that you are trying to create a linked list where the EndDate of the Membership is 1 Less than the start date of the next member_period.

The problem...

I'm not sure that setting the seed to the next number in logical order is the right way, Personally I would be setting the seed to start from a number...

There are some features that im looking forward to testing, especially the Lineage and Object Dependancy part of SSMS.

Of the New T-SQL commands THROW and the new addtions to the...

What is the insert volume of the table, as you really dont want to be initiating an SSIS package on every Insert if theres a high volumne of Inserts, as...

Koen Verbeeck (2/22/2011)

---

I've done the MCTS BI exam in November 2010 and the MCITP BI exam this January, and I didn't notice anything abnormaly difficult. Maybe different region equals different...

_Tups_ (2/21/2011)

---

Okay found the answer from a post on

http://social.msdn.microsoft.com

I never set the default member and I never set the isaggregate to false on the LatestFlag dimension...

So any of the...