Daniel Fischer is the first Stack Exchange user to reach 100K on two sites, excluding Meta Stack Exchange. Nobody else has reach 75K on two non-meta sites yet. Query
When I try to run the query I get an error: The server principal "STACKEXCHANGE\svc_sede" is not able to access the database "StackExchange.Tex_Temp" under the current security context.
Is that just a temporary thing, or has something changed since the query was created and it no longer works?
When I tried your multisite query I also got an error. This time, the error message is: Invalid object name 'StackExchange.Programmers_Temp.dbo.posts'.
The [name of db]_Temp is an unintended leftover of the import process.
In this answer Nick links to the stored procedure that takes care of the import.
Here are the most relevant parts:
CREATE PROCEDURE [dbo].[sp_Refresh_Database] @DBName nvarchar(100)
AS
BEGIN
Declare @TempDBName varchar(...
The [name of db]_Temp is an unintended leftover of the import process.
In this answer Nick links to the stored procedure that takes care of the import.
Here are the most relevant parts:
CREATE PROCEDURE [dbo].[sp_Refresh_Database] @DBName nvarchar(100)
AS
BEGIN
Declare @TempDBName varchar(...
