Hi Abhijit,

Thanks for the reply.

So if i cant find any dependacies on columns with the different collation i could do a simple ALTER DATABASE?

Am i on the right track...

Second one solved! It needed double ' around the min server memory (MB) like below.

ExecuteSql('Numeric', 'SELECT [value]

FROM sys.configurations

WHERE [name] = ''min server memory (MB)''')

Oh! thanks Gila,

Im on 2012, must have changed then!?

never thought that it might be that...

Thanks!

Hi,

ive tried the following and still getting the same error..

http://sqlfool.com/2010/06/check-vlf-counts/[/url]

Create Table #stage(

FileID int

, FileSize bigint

...

hey thanks for the replies..

Could anyone expand a little bit.

How is data put into files? random?, round robin?, fill one then move on to the next?

Ive seen a...

Thanks for the reply 🙂

Its a not a deadlock, one is blocking another query. not blocking each other (ie session 160 is blocking 230. 230 is blocking 400)..

So...

hi Ed,

Thanks for the reply..

still digging around trying to resolve it, possibility missing the point! (cant see the wood though the trees)

But using something like

USE Master

GO

SELECT *...

Hi Jason

Makes sense!

Thanks

Hi Lynn

Thanks for the reply! I know its a very grey area, in my old shop i got told completely different info from MS direct depending on who i...

Resolved it.

Found this on SQLCentral. (didn't pop up in my google searchs 🙁 ) which is 80% of what i wanted. I redid my report again using this...

trans log backups are every 30 mins so with it taking so long they would have come into play yes.

guessing its better to drop a db by putting it...

Hi!

sp_who and activity monitor

either show any connections to the db.

After changing the maintenace plans to not include the db for backups its let me drop it with

-- DROP DATABASE...

Resolved.

I had missed the .Value for the AND parts.

=Switch (

Fields!Enabled.Value = 0 , "DarkRed",

Fields!Enabled.Value = 1 AND Fields!ID.Value = "The job failed.", "RosyBrown",

Fields!Enabled.Value = 1 AND Fields!ID.Value =...

Well thought i had the logic for it right. But not sure how SSRS does nulls? and well this doent work anyway. but I have

Enabled Col can either be...

Thanks John!

that's showing the change to advanced settings for me

so many ways to do things.. All look a lot cleaner and nicer than mine!

Thank you 🙂