Information générale
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement