Error 208 Sql Server 2005
Contents |
SERVER - Error: Fix - Msg 208 - Invalid object name ‘dbo.backupset' - Invalid object name ‘dbo.backupfile' August 31, 2012Pinal DaveSQL, SQL Server, SQL microsoft sql server error 208 Tips and Tricks53 commentsJust a day before I got sql server error 208 severity 16 state 0 a very interesting email. Here is the email (modified a bit to make it relevant
Msg 208 Sql Server
to this blog post)."Pinal,We are facing a very strange issue.One of our query related to backup files and backup set has stopped working suddenly in
Erro 208 Sql Server
SSMS. It works fine in application where we have and in the stored procedure but when we have it in our SSMS it gives following error.Msg 208, Level 16, State 1, Line 1 Invalid object name ‘dbo.backupfile'.Here are our queries which we are trying to execute. SELECT name, database_name, backup_size, TYPE,
compatibility_level, backup_set_id
FROM dbo.backupset;
SELECT logical_name, backup_size, file_type
FROM dbo.backupfile;This query gives us details related to backupset and backup files when the backup was taken."When I receive this kind of email, usually I have no answers directly. The claim that it works in stored procedure and in application but not in SSMS gives me no real data. I have requested him to very first check following two things:If he is connected to correct server? His answer was yes.If he has enough permissions? His answer was he was logged in as an admin.This means there was something more to it and I requested him to send me a screenshot of the his SSMS. He promptly sends
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Sql Server 208 R2 Download
policies of this site About Us Learn more about Stack Overflow the sqlserver error 208 company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users invalid object name error in sql server Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes http://blog.sqlauthority.com/2012/08/31/sql-server-error-fix-msg-208-invalid-object-name-dbo-backupset-invalid-object-name-dbo-backupfile/ a minute: Sign up SQL Server: invalid object name how to solve it? up vote 2 down vote favorite error returns to me in below codes: Msg 208, Level 16, State 1, Line 1 Invalid object name 'ENG_PREP'. insert into ENG_PREP VALUES('572012-01-1,572012-01-2,572012-01-3,572013-01-1,572013-01-2', '', '500', '', 'A320 P.001-A', 'Removal of the LH Wing Safety Rope', '', '', '', '0', '', 'AF', '12-00-00-081-001', '', http://stackoverflow.com/questions/3069356/sql-server-invalid-object-name-how-to-solve-it '', '', '', '', '', '' ) sql sql-server-2005 share|improve this question edited Jun 18 '10 at 16:09 marc_s 452k938641029 asked Jun 18 '10 at 12:00 Penguen 4,1472982151 Well, it just means that in whatever database you're running your query, there is no "ENG_PREP" table. Were you running this in Management Studio and maybe accidentally left it on [master]? put a USE [YourDatabaseName] at the top of that and see what happens. –Cᴏʀʏ Jun 18 '10 at 12:03 add a comment| 5 Answers 5 active oldest votes up vote 4 down vote It means that it doesn't know what ENG_PREP is. You need to use a 'use xxx' (where xxx is the database name where the ENG_PREP lives) command first to tell it what database you are using. And once you do that, you need to make sure that ENG_PREP is present in that database. If you're using .Net to connect, you need to make sure you specify the initial catalog so it knows what database to use, here's an example excerpt from a web.config: