It is probably because the user has not yet been added to a server group outside of SQL. Try logging in as sa and then managing the users through...

Joshua D Gang (12/15/2011)

---

I am positive nothing was changed on the service account as it used on all SQL servers as the service account. The error message is as follows

initerrlog:...

I have had this happen before when we created new locations for data or log files, deleted the default folders (no files were in them), but never changed the default...

How come nobody mentioned "Restart SQL Server service or Windows" in any posts? We are, after all, working with Microsoft... 🙂

"Have you tried turning it on and off again?" -IT...

ricardo_chicas (12/15/2011)

---

fot the last 16 hours I've been trying to shrink the log file, it is 35gb now, I am the only user, I close all access to the server...

sroumel (12/14/2011)

---

My thought ... almost

select y.status, COUNT(*)as meter_cnt

from (

select case

when x.recission_date > x.flow_end_date then 'cancelled'

when x.flow_end_date IS null and x.flow_start_date IS not null then 'active'

when...

select COUNT(*)as meter_cnt

from (

select case

when x.recission_date > x.flow_end_date then 'cancelled'

when x.flow_end_date IS null and x.flow_start_date IS not null then 'active'

when x.flow_end_date IS not null then 'churn'

else 'in transit'

end status

from

(select cal2.sale_Date,

cal2.recission_date,

cal2.flow_start_date,

cal2.flow_end_Date,

cal2.esiid,

ROW_NUMBER()...

I have used Red-Gate's SQL Data Compare at 2 different companies and think it is great. Mainly because of all of the options that it has to compare and...

Ninja's_RGR'us (12/14/2011)

---

I don't know for sure about dev but most of us are far beyond good & great.

1+1=2. ...

It seems to me that solutions are being provided and you are failing to implement them. Why did you come...

p-nut (12/13/2011)

---

ankurk2 (12/13/2011)

---

with this expression:

=MonthName(Month(Fields!new_sitevisiteddateutc.Value))& "-"& Year(Fields!new_sitevisiteddateutc.Value)

I am easily getting what i want but can't sort it . Can you tell me in detail.

One more thing this new column...

ankurk2 (12/13/2011)

---

with this expression:

=MonthName(Month(Fields!new_sitevisiteddateutc.Value))& "-"& Year(Fields!new_sitevisiteddateutc.Value)

I am easily getting what i want but can't sort it . Can you tell me in detail.

One more thing this new column is...

ankurk2 (12/13/2011)

---

I have a date column. I created Month-Year column in my report using expression:

=MonthName(Month(Fields!new_sitevisiteddateutc.Value))& "-"& Year(Fields!new_sitevisiteddateutc.Value)

But I am not able to sort month-year wise.

Like I want MAY-2009 JUNE-2009 JANUARY-2011...

Ajdba (12/13/2011)

---

Hello,

I am trying to replace set of hard-coded datetime with datetimes dynamically captured; but the result I am getting are not same, can somebody suggest what I am missing.

Tnx

...

Thanks Gail!

Jared