Does this work for you?

SELECT
  CallNumber,
  EquipmentFk,
  InvoiceNum,
  CallDate,
  OrderNum,
  OrderDate
FROM
    (
    SELECT
            ROW_NUMBER()...

What happens if you execute the following SQLCMD command from a command prompt?
sqlcmd -U username -P password -S server\dbase -Q"SELECT * FROM sys.databases"


This command...

Have you run the installation with administrator privileges?  --> right click the executable and select "run as administrator"

By my understanding in this case most of the post migration tasks does not need to be performed. Because the versions stay the same all indexes, statistics and usage stats...

Btw: if you need to fill non-matching rows using information from other (previous) rows, take a look at the LEAD and LAG functions. This article on DatabaseJournal.com has a...

I've completed your query sample to include the filling of the tally table.
From your sample I notice a few mistakes. First you need a RIGHT outer join instead of...

Like Thom said already, it is quite possible to create such a view.
To select such a result I suggest to use a tally date table. Such a table...

I have modified my previous query a bit. The query below displays ALL deny permissions in the database and shows to which account or role it is granted. The last...

Being an invisible DBA is the goal for everyone who want's to be pro-active instead of re-active. A pro-active approach also saves time which can be used for the more...

removed this post
it was a remark that was already clearly mentioned in the original post :Whistling: