Questions tagged [invalid-object-name]
26 questions
0
votes
0 answers
Remote Call Compiles SPROC differently to local, causes error
I have a stored proc that returns details of SQL Agent Jobs on the local server. There is a master script that calls this proc, using OPENQUERY, against every SQL server in the ecosystem. In pseudocode, the master script looks something like…
High Plains Grifter
- 1,357
- 1
- 12
- 36
0
votes
0 answers
Excel Invalid Object Name when using a temp table and a parameter
When I create a connection to SQL in Excel that has a temp table for a lookup and I hard code the parameters for the SQL query, everything runs fine. When I change the hard coded parameters to ? to be able to use dynamic parameters from a cell, I…
0
votes
1 answer
SQL maintenance job failing: "Invalid object name 'Confluence.sys.Partitions'. Changed database context to 'master'
My database is called "Confluence". The maintenance job has always failed since that job was setup 6 months ago. Attempting to run the job manually also fails with same error.
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server…
c c
- 11
- 3
0
votes
0 answers
create table from if statement SQL
I have this code in my SQL, however the if statement seems to be not working at all. Every time I run the query below.. I always have an error that says...
Msg 2714, Level 16, State 1, Line 39
There is already an object named '##TEMP1' in the…
Magpie737
- 3
- 1
0
votes
1 answer
Invalid objects while upgrading Oracle 12c to 18c
180 objects are invalid in pre-requisite even after running utlrp.sql while upgrading oracle 12c to 18c.
When running EXECUTE DBMS_PREUP.INVALID_OBJECTS, I am getting APEX packages in the output which I have upgraded from 4.2 to latest 19. See more…
0
votes
0 answers
Bulk Insert, Invalid Object Error (table name), Excel VBA to SQL Server
I am trying to bulk load from a CSV file to an SQL Server (both Excel and SQL Server are sitting on my laptop). I am doing this via Excel VBA using the "bulk insert" statement. I keep getting a run-time error of invalid object name for my table. …
Ron
- 1
- 1
0
votes
0 answers
SSRS Report Error Invalid Object Name System.Data.SqlClient.SqlException: Invalid object name 'tempdb.dbo.TEMP_ID_XXXX'
I am facing a weird problem and I would be glad if anyone can help me.
In our company we use SSRS to send daily Reports to the Same Management.
We Have 3 Types of Reports, which of 3 is executed more times with different parameters. The first it is…
Gio
- 1
- 2
0
votes
2 answers
Invalid Object Name jdbc connection with sql server 2014
I have been looking for the solution from 2 days and tried everything but still i am not able to resolve the issue i am facing.
Issue : Invalid object name 'Info'
package test;
import java.sql.*;
public class DataConn {
public static void…
topper1309
- 151
- 3
- 16
0
votes
2 answers
invalid object name
I have a table that gets deleted and re created in milliseconds(cant just insert and delete). Of course this occurs sometimes when another stored procedure is running and trying to call that table. How would I avoid this? I have tried 'waitfor' xx…
Chris
- 1
- 1
0
votes
0 answers
Synonyms in stored procedure - error Invalid Object Name
I am using synonym in stored procedure (SP) to run select on the linked databases. The database name is calculated based on the input of the SP. The SP works fine most of the time, but if the same SP is called multiple times via a program, I get…
user3525199
- 11
- 1
- 2
0
votes
2 answers
Azure Database Installation Error "Invalid Object name 'Categories' "
I am completely ignorant in relation to databases and servers etc. Please bear with me.
I am trying to install a program called RealProspect 2009 which allows both local and remote sql database installation. Both types are done using the program…
Chris Peisher
- 1
- 2