Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sp_help
Message
De
23/05/2003 04:19:25
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Sp_help
Divers
Thread ID:
00792091
Message ID:
00792091
Vues:
89
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
Fil
Voir

Click here to load this message in the networking platform