Thread: What SQL server and databases are open?
View Single Post
 
Old 03-02-2014, 05:28 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
IMHO, you're going about this the wrong way. If the SQL is supposed to work with a particular database, the code should used a fully-qualified database name; not simply work with whatever 'production' database the user has open.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote