Trust no one.

My wife had the best. She worked for a brewery and got a case and 1/2 of beer every two weeks, four pony kegs a year, discount on beer above...

At a previous employer, I had external auditors impressed with Idera's tools. I'm not sure how they compare cost wise to other companies, but I have a feeling they are...

Did the Top 10 SQL Server Mistakes and Mis-steps ever happen? I wasn't able to get back in after the time zone mix up in the beginning.

Tim

Sorry Tara,

That was almost two years and one job ago. My memory doesn't reach back that far. Best of luck.

Tim

Never mind, I figured it out. I was trying to use another parameter instead of just using the .Label attribute of the existing parameter.

Tim

That's great help, thank you!

Tim

Thanks guys.

Paul, it's on 64 bit (OS and SQL) already.

Jeff, it's a week number calculation. Depending on the day of the week of Jan 1 and how you calculate it...

I've already agreed with the developers to recode this skipping the CLR as it's a simple date calculation. I'm not sure why they went CLR in the first place. Until...

Yeah, that will work, but I'm looking for something a little more GUIrific for a client to be able to use after I'm gone.

So far the SQLScheduler from Lazy Coding...

Got it.

When I RDP to the server (admin account) and run SSMS as the normal user it works.

When I try and run SSMS from my client (normal user) running...

I'm not sure if I understand your post 🙂

The Users group on the server has Our domain/Domain Users so everyone has access to this server.

Is there something else?

Thanks,

Tim

Um, nevermind. I've got it. :ermm:

Need vacation

Perfect, thanks again Steve!

Further investigation shows..

Working SSRS server: .NET 2.0 (x64) and .NET 3.0 Frameworks installed

Non-working SSRS server: .NET 1.1 and .NET 2.0 (x64) Frameworks installed

SSRS 2005 requires 2.0 not 3.0, right?

Thanks,

Tim