Member Avatar for erum

i m working on certain project ,i created some tables in database sql server 2005 .and it created smoothly. for examples users table .so it append it with dbo.users .till there there was no problem i can easily access its object (table,storeed procedure) .but after few days it appended table name with user login of sql server 2005 like 'shmai.Conference'. ('shmai is userlogin of sql server2005) and i m unable to access it via .net code

it gives exception like this
Invalid object name 'shmai.Conference'.

how to resolve it!!

  • 2 Contributors
  • 1 Reply
  • 144 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by eralper
Member Avatar for eralper

Did you try enclosing with [ and ] like
select * from [Sales].[CountryRegionCurrency]

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.