SQL Server Error Explenation - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server Error Explenation

Author

Topic

bholbrook
Starting Member

2 Posts

Posted - 2006-12-12 : 12:40:32

Hello

I am new to SQL Server using Microsoft SQL Server Management Studio for SQL Server 2005 and I am receiving the following error on the following query.

Error
Could not locate entry in sysdatabases for database 'dbo'. No entry found with that name. Make sure that the name is entered correctly.

Query
USE dbo.automotiveFixer
GO

SELECT vma.LuCode, vmo.LuCode, ws.WoNumber, ws.RefinishHours, ws.RepairHours, ws.ReplaceHours,
av.BuildYear, av.License, av.BodyColor, wo.WorkorderNumber
FROM dbo.autoWorkOrder wo
INNER JOIN dbo.autoVehicle av ON av.VehicleID = wo.VehicleID
INNER JOIN dbo.autoWoSummary ws ON ws.WorkorderID = wo.WorkOrderID
INNER JOIN dbo.autLuVehicleMake vma ON vma.LookupID = av.MakeID
INNER JOIN dbo.autLuVehicleModel vmo ON vmo.LookupID = av.ModelID

Never let your project define your product, make your product define your project.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2006-12-12 : 12:53:36

use ~~dbo.~~automotiveFixer

Be One with the Optimizer
TG

bholbrook
Starting Member

2 Posts

Posted - 2006-12-12 : 12:55:11

Thank you sir.
My college beat you by a literal nanosecond.

Your time is appreciated.

Optimizer?

Never let your project define your product, make your product define your project.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources