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.
DevboardProddboDB.TaskTransaction BASE TABLE
DevboardProddboHoursExtractView VIEW
DevboardProddboCHANGES_HISTORY BASE TABLE
DevboardProddboTaskStatusHistoryExtractView VIEW
DevboardProddboDB.Document BASE TABLE
DevboardProddboTaskCommentsExtractView VIEW
DevboardProddboProjectsExtractView VIEW
DevboardProddboDB.FunctionalGroupsBASE TABLE
DevboardProddboProjectMilestonesExtractViewVIEW
DevboardProddboDB.ModifyTaskStatusHistory_viewVIEW
DevboardProddboProjectSiteRelationsExtractViewVIEW
DevboardProddboDB.ModifyProjectStatusHistory_viewVIEW
DevboardProddboProjectTaskRelationsExtractViewVIEW
DevboardProddboDB.FreeTask_view_newVIEW
DevboardProddboSWCExtractViewVIEW
DevboardProddboRequests_oldBASE TABLE
DevboardProddboTasksCommentsExtractViewVIEW
DevboardProddboTasksExtractViewVIEW
DevboardProddboUsersExtractViewVIEW
DevboardProddboDB.Project_oldBASE TABLE
DevboardProddbodtpropertiesBASE TABLE
DevboardProddboFlextronics.ChangesLogRootBASE TABLE
DevboardProddboFlextronics.ChangesTransactionBASE TABLE
DevboardProddboT1E3D37C5-AADB-41B5-93BA-C2CD1F3937F9BASE TABLE
DevboardProddboDB.TaskComponentBASE TABLE
DevboardProddboFlextronics.ChangesItemBASE TABLE
DevboardProddboDB.ExtractSetupBASE TABLE
DevboardProddboT42C79AE6-CDA1-42C1-9D73-2E55197158CABASE TABLE
DevboardProddboFlextronics.DataMapping.ExceptionsBASE TABLE
DevboardProddboFlextronics.DataMapping.TimeLogBASE TABLE
DevboardProddboFlextronics.Security.UsersBASE TABLE
DevboardProddboFlextronics.Security.RolesBASE TABLE
DevboardProddboKeyWordsBASE TABLE
DevboardProddboDB.SiteRelationBASE TABLE
DevboardProddboFlextronics.Messaging.TemplateBasesBASE TABLE
DevboardProddboDB.DevCenterBASE TABLE
DevboardProddboDB.ComponentTypeBASE TABLE
DevboardProddboDB.Task_oldBASE TABLE
DevboardProddboDB.CommentsBASE TABLE
DevboardProddbohoursBASE TABLE
DevboardProddboDB.ReferencesRootBASE TABLE
DevboardProddbotask_status_historyBASE TABLE
DevboardProddboDB.MilestoneBASE TABLE
DevboardProddboDB.TaskComponentViewVIEW
DevboardProddboT7FD37854-243A-4C32-9BD2-3AA11F5CDEF1BASE TABLE
DevboardProddboDB.RulesBASE TABLE
DevboardProddboT8618BA0C-EA15-40BE-AAA5-8C180188F0F3BASE TABLE
DevboardProddboT79B30105-F6B1-47E9-87E8-DA024D3C2E54BASE TABLE
DevboardProddboDB.SegmentsBASE TABLE
DevboardProddboDB.ComponentsBASE TABLE
DevboardProddboDB.RequestPrioritiesBASE TABLE
DevboardProddboDB.WorklowBASE TABLE
DevboardProddboDB.RequestToTaskRelationBASE TABLE
DevboardProddboDB.ProjectBASE TABLE
DevboardProddboStandardChangesBASE TABLE
DevboardProddboDB.UserWorkflowVisualizationBASE TABLE
DevboardProddboDB.WorkflowRelationBASE TABLE
DevboardProddboDB.TaskFieldsBASE TABLE
DevboardProddboDB.WorkflowActionsBASE TABLE
DevboardProddboFlextronics.Security.Roles.DefRoleAliasBASE TABLE
DevboardProddboDB.ReasonBASE TABLE
DevboardProddboT36291D57-B710-4DAE-9AA5-DA986C653899BASE TABLE
DevboardProddboFlextronics.Security.AdministrationRootBASE TABLE
DevboardProddboDB.RequestFieldsBASE TABLE
DevboardProddboDB.CustomersBASE TABLE
DevboardProddboT8DDE0CBD-AD31-4B75-86AF-5E16A82F82B8BASE TABLE
DevboardProddboDB.RequestTypesBASE TABLE
DevboardProddboT496E4830-8DDE-40D5-B6DF-D58E482EA5E4BASE TABLE
DevboardProddboDB.TaskTypeWorkFlowBASE TABLE
DevboardProddboDB.RequestsBASE TABLE
DevboardProddboDB.DocumentRepositopyItemsBASE TABLE
DevboardProddboDB.TaskTransactionHistoryBASE TABLE
DevboardProddboDB.DBUserRoleBASE TABLE
DevboardProddboFlextronics.Reporting.TotalFieldsBASE TABLE
DevboardProddboDB.Task_Status_History_oldBASE TABLE
DevboardProddboDB.RoutingProfileBASE TABLE
DevboardProddboFlextronics.Reporting.ReportPivotsBASE TABLE
DevboardProddboFlextronics.Diagnostics.TransactionLogBASE TABLE
DevboardProddboDB.FreeTaskBASE TABLE
DevboardProddboFlextronics.Reporting.SeriesDatasBASE TABLE
DevboardProddboFlextronics.Diagnostics.LogBASE TABLE
DevboardProddboDB.ApprovalBASE TABLE
DevboardProddboFlextronics.Reporting.InteriorsBASE TABLE
DevboardProddboHistory.CollectionItemChangesBASE TABLE
DevboardProddboDB.TaskTypeBASE TABLE
DevboardProddboFlextronics.Reporting.ReportBuildersBASE TABLE
DevboardProddboHistory.MemberChangesBASE TABLE
DevboardProddboDB.RoutingProfileItemBASE TABLE
DevboardProddboFlextronics.Reporting.SortsBASE TABLE
DevboardProddboHistory.CollectionHelpersBASE TABLE
DevboardProddboFlextronics.Reporting.BuilderFilterBASE TABLE
DevboardProddboFlextronics.Messaging.TaskItemsBASE TABLE
DevboardProddboDB.ApprovalChainBASE TABLE
DevboardProddboFlextronics.Reporting.DetailFieldsBASE TABLE
DevboardProddboFlextronics.Messaging.MessageSendersBASE TABLE
DevboardProddboDB.SitesBASE TABLE
DevboardProddboFlextronics.Reporting.ColumnFieldsBASE TABLE
DevboardProddboFlextronics.Messaging.TypeInfoBASE TABLE
DevboardProddboDB.WeeksBASE TABLE
DevboardProddboFlextronics.Reporting.ReportFrameBASE TABLE
DevboardProddboFlextronics.Messaging.LogBASE TABLE
DevboardProddboFlextronics.Messaging.MessagesBASE TABLE
DevboardProddboFlextronics.Reporting.GroupsBASE TABLE
DevboardProddboFlextronics.Messaging.SubscribedEventsBASE TABLE
DevboardProddboDB.ApplicationBASE TABLE
DevboardProddboFlextronics.Reporting.TotalsBASE TABLE
DevboardProddboFlextronics.Messaging.MessageQueueBASE TABLE
DevboardProddboDB.ERPCompanyBASE TABLE
DevboardProddboDB.Project_Status_History_oldBASE TABLE
DevboardProddboFlextronics.Reporting.ReportsBASE TABLE
DevboardProddboFlextronics.Security.DefinedPermissionsBASE TABLE
DevboardProddboDB.BusinessParkBASE TABLE
DevboardProddboFlextronics.Reporting.ReportFoldersBASE TABLE
DevboardProddboDB.BROBASE TABLE
DevboardProddboproject_status_historyBASE TABLE
DevboardProddboFlextronics.Reporting.SeriesBASE TABLE
DevboardProddboDB.AreasBASE TABLE
DevboardProddboFlextronics.Reporting.LinesBASE TABLE
DevboardProddboDB.TaskStatusBASE TABLE
DevboardProddboFlextronics.Reporting.JoinsBASE TABLE
DevboardProddboDB.EmployeesBASE TABLE
DevboardProddboFlextronics.Reporting.ReportChartsBASE TABLE
DevboardProddboDB.DevSystemBASE TABLE
DevboardProddboHoursDatesVIEW
DevboardProddboFlextronics.Reporting.FieldMappingsBASE TABLE
DevboardProddboDB.ProjectRootBASE TABLE
DevboardProddboFlextronics.Reporting.FilterItemParameterBASE TABLE
DevboardProddboDB.HoursBASE TABLE
DevboardProddboFlextronics.Reporting.AggregatesBASE TABLE
DevboardProddboDB.TaskBASE TABLE
DevboardProddboFlextronics.Reporting.CalculatedTotalsBASE TABLE
DevboardProddboDB.TaskRelationBASE TABLE
DevboardProddboTYPESBASE TABLE
DevboardProddboFlextronics.Reporting.ReportFiltersBASE TABLE
DevboardProddboDB.TransactionNotificationBASE TABLE
DevboardProddboT65305F0E-8122-4E00-A86C-62E13E17E140BASE TABLE
DevboardProddboOBJECTSBASE TABLE
DevboardProddboTCC2AF704-D61B-4A77-8955-B132260CECA8BASE TABLE
DevboardProddboFlextronics.Reporting.PivotLoadedChartInstancesBASE TABLE
DevboardProddboDB.FolderBASE TABLE
DevboardProddboFlextronics.Reporting.FilterItemBASE TABLE
DevboardProddboDB.ProjectStatusBASE TABLE
DevboardProddboFIELDSBASE TABLE
DevboardProddboTD1EA0887-78B4-4E49-84ED-E111CA56192CBASE TABLE
DevboardProddboERPSystemBASE TABLE
DevboardProddboT9CED065C-635B-4EE7-A09F-90B8CD09C3D0BASE TABLE
DevboardProddboCOLLECTIONSBASE 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