Replace this WorkRequest_PartRequest.QuantityRequested - Inventory_Utilization.QuantityUtilized
with SUM(WorkRequest_PartRequest.QuantityRequested - Inventory_Utilization.QuantityUtilized)
and then...

I had to make sure all columns used later in my process matched the DATETIME2 datatype.

The datasource we query is live and I think there are times when...

Is the Informix DB linked server a live data source?  I get this issue sometimes when extracting data from a live source system, and re-running this process usually solved it.

These links may be of use to you.  Assuming you just want to move the database files.

System / Master
https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases?view=sql-server-2017
User DBs
https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-2017

HTH
Mark

I changed roles just over a year ago.  Like you I am based in the UK, however I am not sure location really makes a huge difference.

My previous...

Surely now is the time to ignore this and not give it any more attention.  This thread also appears elsewhere in other forums.

And talk of ignoring him is...

Another quick question, whereabouts are you in India again, and what is the local time there?

Thanks

Clearly I was not trying to get personal information.

However does this not seem odd?

And recently there have been a number of...

Thank you for this information.  One more thing before we can process this.

Could you please post details of the view that is causing the problem.  I have been...

Thank you so much for your truly invaluable service to the SQL Server Community.

At Microsoft we value your feedback.  This bug does indeed sound very serious.  Would you...

Hi Dev,
Could you please give more details.

Is this a copy of the SQL data tables?  Could you not just link to the SQL tables in your Access...

To pick up on John's point, you need to copy the dtsx package to the server itself to a folder which would then be accessible by SQL Agent, rather than...

Hi Maria,

Try this.

Go to the properties of your report,...

If you right click on the database name and choose
Tasks
then
Generate Scripts
You can export all the tables, etc into one script or individual scripts.

You...