General information
Forum:
Microsoft SQL Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only