Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sp_help
Message
From
23/05/2003 04:19:25
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Sp_help
Miscellaneous
Thread ID:
00792091
Message ID:
00792091
Views:
95
Hi,
I'm trying to learn sql serve and I've been playing around with it at work and at home. When I'm at home if I type:
exec sp_help customers
I get sp_help returned for a table I've got called customers.

When I'm at work I get error messages saying that the table can't be found unless I include the owner and encase the whole thing in speech marks:
exec sp_help 'accounts.customers'
Can anyone please tell me if there's some sort of setting in sql server which causes this and if so what is it? Or am I mad.
Next
Reply
Map
View

Click here to load this message in the networking platform