Not quite the same error you got, but same error number - https://dataginger.com/2012/10/07/msg-2555-level-16-state-1-line-1-error-dbcc-shrinkfile-with-emptyfile-option/

Their solution was to restart the SQL instance and try again. It was likely caused by a query...

That is not a lot to go on. Can you provide sample output and what you have tried? What you provided doesn't tell me enough to give you anything meaningful.

What...

I would recommend asking on a Python forum or a MySQL forum, not a Microsoft SQL Server forum, but that's just me.

But because I'm a sucker, I'll try to help...

You can do that from a stored procedure, but I am pretty sure you can't from a function.

And to be honest, I'm not even sure how you'd do that in...

Brian, just to let you know, I got it to work! The client had not been uploading the correct version of the rdl. I had manually changed one to...

One line makes me shudder:

There is no recipe that does not include some kind of starter (either Poolish or Sourdough starter).

So does Poolish (a recipe) ALSO have a starter? If...

Yeah, so your report builder is too new for that SSRS. Best bet is to change the project configuration to use an older SSRS, which is answer number 2 in...

To add to what Grant says - "generating" a baseline from a point in time is often useless. My recommendation is to use a monitoring tool and gathering metrics over...

A 30 hour rollback kind of makes me think something was using explicit transactions and not committing them and held a connection for a long time. Had that happen on...

To me that sounds like you are using a newer or older version of report builder than the server expects. I would uninstall report builder from your machine, download it...

To add to the question on losing a connection that may be in a transaction,

We have had site down maintenance and to where the network is just brought down....

• This reply was modified 1 year, 4 months ago by Mr. Brian Gale.

Something to note - if you HAVE indexed views in place, you can update your queries to use query hints in Standard that will use the indexes on the view....

I agree with ratbak here. But I would also like to point out that with so few data points, the estimates are going to be a bit off. But eyeballing...

Possibly a silly question but did you set up the SPN's when you installed the new instance?

Correct me if I am wrong, but isn't the error a login related issue, not a database related issue?

To me it sounds like the server cert is not recognized or...