« first day (610 days earlier)   

4:45 AM
in In praise of Math.SE site and its users on The Stack Exchange Network Chat, Jan 7 '15 at 3:53, by Fundamental
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
The message contains link to the query called "Find users with highest rep on multiple sites"
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'.
 
 
2 hours later…
6:35 AM
@Martin yeah, the restore / refresh is running
6
A: What's the Codegolf_Temp database (and why does it mess up my query)?

reneThe [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(...

 
6:53 AM
Thanks for the response!
And it is good that it is shown also on Meta Stack Exchange.
 
yw
 
 
6 hours later…
 
2 hours later…
 
2 hours later…

« first day (610 days earlier)