September 3, 2008 at 10:44 am
who's the owner??
if you run as sa, drop the dbo part and test again.
Could also be a view that tries to select from the base table which does not include the bracket.
Keep digging into objects, our code works, so there's something else.
September 3, 2008 at 10:49 am
well guess what? It worked. all what i did was:
select * from dbo.[DB.Documents] -- Yes changed the DB.D to Upper case --- thats how the table is defined and it worked like a charm.
seems like the issue was with Upper case DB.D. but finally its working which is very good news.
Would like to thank everyone for contributing to this.
Thanks again,
September 3, 2008 at 10:51 am
Execute the following command and post the results:
SELECT * From INFORMATION_SCHEMA.TABLES
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 3, 2008 at 10:54 am
The question now, is it possible to change the server settings from CS to CI... never tried it and I have no solutions on top of my head.
September 3, 2008 at 1:23 pm
Barryoung - here's the requested info.
DevboardProd dbo DB.TaskTransaction BASE TABLE
DevboardProd dbo HoursExtractView VIEW
DevboardProd dbo CHANGES_HISTORY BASE TABLE
DevboardProd dbo TaskStatusHistoryExtractView VIEW
DevboardProd dbo DB.Document BASE TABLE
DevboardProd dbo TaskCommentsExtractView VIEW
DevboardProd dbo ProjectsExtractView VIEW
DevboardProd dbo DB.FunctionalGroups BASE TABLE
DevboardProd dbo ProjectMilestonesExtractView VIEW
DevboardProd dbo DB.ModifyTaskStatusHistory_view VIEW
DevboardProd dbo ProjectSiteRelationsExtractView VIEW
DevboardProd dbo DB.ModifyProjectStatusHistory_view VIEW
DevboardProd dbo ProjectTaskRelationsExtractView VIEW
DevboardProd dbo DB.FreeTask_view_new VIEW
DevboardProd dbo SWCExtractView VIEW
DevboardProd dbo Requests_old BASE TABLE
DevboardProd dbo TasksCommentsExtractView VIEW
DevboardProd dbo TasksExtractView VIEW
DevboardProd dbo UsersExtractView VIEW
DevboardProd dbo DB.Project_old BASE TABLE
DevboardProd dbo dtproperties BASE TABLE
DevboardProd dbo Flextronics.ChangesLogRoot BASE TABLE
DevboardProd dbo Flextronics.ChangesTransaction BASE TABLE
DevboardProd dbo T1E3D37C5-AADB-41B5-93BA-C2CD1F3937F9 BASE TABLE
DevboardProd dbo DB.TaskComponent BASE TABLE
DevboardProd dbo Flextronics.ChangesItem BASE TABLE
DevboardProd dbo DB.ExtractSetup BASE TABLE
DevboardProd dbo T42C79AE6-CDA1-42C1-9D73-2E55197158CA BASE TABLE
DevboardProd dbo Flextronics.DataMapping.Exceptions BASE TABLE
DevboardProd dbo Flextronics.DataMapping.TimeLog BASE TABLE
DevboardProd dbo Flextronics.Security.Users BASE TABLE
DevboardProd dbo Flextronics.Security.Roles BASE TABLE
DevboardProd dbo KeyWords BASE TABLE
DevboardProd dbo DB.SiteRelation BASE TABLE
DevboardProd dbo Flextronics.Messaging.TemplateBases BASE TABLE
DevboardProd dbo DB.DevCenter BASE TABLE
DevboardProd dbo DB.ComponentType BASE TABLE
DevboardProd dbo DB.Task_old BASE TABLE
DevboardProd dbo DB.Comments BASE TABLE
DevboardProd dbo hours BASE TABLE
DevboardProd dbo DB.ReferencesRoot BASE TABLE
DevboardProd dbo task_status_history BASE TABLE
DevboardProd dbo DB.Milestone BASE TABLE
DevboardProd dbo DB.TaskComponentView VIEW
DevboardProd dbo T7FD37854-243A-4C32-9BD2-3AA11F5CDEF1 BASE TABLE
DevboardProd dbo DB.Rules BASE TABLE
DevboardProd dbo T8618BA0C-EA15-40BE-AAA5-8C180188F0F3 BASE TABLE
DevboardProd dbo T79B30105-F6B1-47E9-87E8-DA024D3C2E54 BASE TABLE
DevboardProd dbo DB.Segments BASE TABLE
DevboardProd dbo DB.Components BASE TABLE
DevboardProd dbo DB.RequestPriorities BASE TABLE
DevboardProd dbo DB.Worklow BASE TABLE
DevboardProd dbo DB.RequestToTaskRelation BASE TABLE
DevboardProd dbo DB.Project BASE TABLE
DevboardProd dbo StandardChanges BASE TABLE
DevboardProd dbo DB.UserWorkflowVisualization BASE TABLE
DevboardProd dbo DB.WorkflowRelation BASE TABLE
DevboardProd dbo DB.TaskFields BASE TABLE
DevboardProd dbo DB.WorkflowActions BASE TABLE
DevboardProd dbo Flextronics.Security.Roles.DefRoleAlias BASE TABLE
DevboardProd dbo DB.Reason BASE TABLE
DevboardProd dbo T36291D57-B710-4DAE-9AA5-DA986C653899 BASE TABLE
DevboardProd dbo Flextronics.Security.AdministrationRoot BASE TABLE
DevboardProd dbo DB.RequestFields BASE TABLE
DevboardProd dbo DB.Customers BASE TABLE
DevboardProd dbo T8DDE0CBD-AD31-4B75-86AF-5E16A82F82B8 BASE TABLE
DevboardProd dbo DB.RequestTypes BASE TABLE
DevboardProd dbo T496E4830-8DDE-40D5-B6DF-D58E482EA5E4 BASE TABLE
DevboardProd dbo DB.TaskTypeWorkFlow BASE TABLE
DevboardProd dbo DB.Requests BASE TABLE
DevboardProd dbo DB.DocumentRepositopyItems BASE TABLE
DevboardProd dbo DB.TaskTransactionHistory BASE TABLE
DevboardProd dbo DB.DBUserRole BASE TABLE
DevboardProd dbo Flextronics.Reporting.TotalFields BASE TABLE
DevboardProd dbo DB.Task_Status_History_old BASE TABLE
DevboardProd dbo DB.RoutingProfile BASE TABLE
DevboardProd dbo Flextronics.Reporting.ReportPivots BASE TABLE
DevboardProd dbo Flextronics.Diagnostics.TransactionLog BASE TABLE
DevboardProd dbo DB.FreeTask BASE TABLE
DevboardProd dbo Flextronics.Reporting.SeriesDatas BASE TABLE
DevboardProd dbo Flextronics.Diagnostics.Log BASE TABLE
DevboardProd dbo DB.Approval BASE TABLE
DevboardProd dbo Flextronics.Reporting.Interiors BASE TABLE
DevboardProd dbo History.CollectionItemChanges BASE TABLE
DevboardProd dbo DB.TaskType BASE TABLE
DevboardProd dbo Flextronics.Reporting.ReportBuilders BASE TABLE
DevboardProd dbo History.MemberChanges BASE TABLE
DevboardProd dbo DB.RoutingProfileItem BASE TABLE
DevboardProd dbo Flextronics.Reporting.Sorts BASE TABLE
DevboardProd dbo History.CollectionHelpers BASE TABLE
DevboardProd dbo Flextronics.Reporting.BuilderFilter BASE TABLE
DevboardProd dbo Flextronics.Messaging.TaskItems BASE TABLE
DevboardProd dbo DB.ApprovalChain BASE TABLE
DevboardProd dbo Flextronics.Reporting.DetailFields BASE TABLE
DevboardProd dbo Flextronics.Messaging.MessageSenders BASE TABLE
DevboardProd dbo DB.Sites BASE TABLE
DevboardProd dbo Flextronics.Reporting.ColumnFields BASE TABLE
DevboardProd dbo Flextronics.Messaging.TypeInfo BASE TABLE
DevboardProd dbo DB.Weeks BASE TABLE
DevboardProd dbo Flextronics.Reporting.ReportFrame BASE TABLE
DevboardProd dbo Flextronics.Messaging.Log BASE TABLE
DevboardProd dbo Flextronics.Messaging.Messages BASE TABLE
DevboardProd dbo Flextronics.Reporting.Groups BASE TABLE
DevboardProd dbo Flextronics.Messaging.SubscribedEvents BASE TABLE
DevboardProd dbo DB.Application BASE TABLE
DevboardProd dbo Flextronics.Reporting.Totals BASE TABLE
DevboardProd dbo Flextronics.Messaging.MessageQueue BASE TABLE
DevboardProd dbo DB.ERPCompany BASE TABLE
DevboardProd dbo DB.Project_Status_History_old BASE TABLE
DevboardProd dbo Flextronics.Reporting.Reports BASE TABLE
DevboardProd dbo Flextronics.Security.DefinedPermissions BASE TABLE
DevboardProd dbo DB.BusinessPark BASE TABLE
DevboardProd dbo Flextronics.Reporting.ReportFolders BASE TABLE
DevboardProd dbo DB.BRO BASE TABLE
DevboardProd dbo project_status_history BASE TABLE
DevboardProd dbo Flextronics.Reporting.Series BASE TABLE
DevboardProd dbo DB.Areas BASE TABLE
DevboardProd dbo Flextronics.Reporting.Lines BASE TABLE
DevboardProd dbo DB.TaskStatus BASE TABLE
DevboardProd dbo Flextronics.Reporting.Joins BASE TABLE
DevboardProd dbo DB.Employees BASE TABLE
DevboardProd dbo Flextronics.Reporting.ReportCharts BASE TABLE
DevboardProd dbo DB.DevSystem BASE TABLE
DevboardProd dbo HoursDates VIEW
DevboardProd dbo Flextronics.Reporting.FieldMappings BASE TABLE
DevboardProd dbo DB.ProjectRoot BASE TABLE
DevboardProd dbo Flextronics.Reporting.FilterItemParameter BASE TABLE
DevboardProd dbo DB.Hours BASE TABLE
DevboardProd dbo Flextronics.Reporting.Aggregates BASE TABLE
DevboardProd dbo DB.Task BASE TABLE
DevboardProd dbo Flextronics.Reporting.CalculatedTotals BASE TABLE
DevboardProd dbo DB.TaskRelation BASE TABLE
DevboardProd dbo TYPES BASE TABLE
DevboardProd dbo Flextronics.Reporting.ReportFilters BASE TABLE
DevboardProd dbo DB.TransactionNotification BASE TABLE
DevboardProd dbo T65305F0E-8122-4E00-A86C-62E13E17E140 BASE TABLE
DevboardProd dbo OBJECTS BASE TABLE
DevboardProd dbo TCC2AF704-D61B-4A77-8955-B132260CECA8 BASE TABLE
DevboardProd dbo Flextronics.Reporting.PivotLoadedChartInstances BASE TABLE
DevboardProd dbo DB.Folder BASE TABLE
DevboardProd dbo Flextronics.Reporting.FilterItem BASE TABLE
DevboardProd dbo DB.ProjectStatus BASE TABLE
DevboardProd dbo FIELDS BASE TABLE
DevboardProd dbo TD1EA0887-78B4-4E49-84ED-E111CA56192C BASE TABLE
DevboardProd dbo ERPSystem BASE TABLE
DevboardProd dbo T9CED065C-635B-4EE7-A09F-90B8CD09C3D0 BASE TABLE
DevboardProd dbo COLLECTIONS BASE TABLE
September 3, 2008 at 1:31 pm
California (9/3/2008)
well guess what? It worked. all what i did was:select * from dbo.[DB.Documents] -- Yes changed the DB.D to Upper case --- thats how the table is defined and it worked like a charm.
seems like the issue was with Upper case DB.D. but finally its working which is very good news.
Would like to thank everyone for contributing to this.
Thanks again,
That's what I was about to suggest. You must have a case sensitive collation on the DB or SQL instance.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply