|
|
Posted by SQL on 06/21/06 13:27
select * from master..sysdatabases
where name ='mail.archive'
mdf is not part of the name
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Prem wrote:
> Apparently the query analyser of sql server does not recognise a
> database with a point in it, like
> mail.archive.mdf
>
> I receive the following error when I use it:
>
> Server: Msg 911, Level 16, State 1, Line 1
> Could not locate entry in sysdatabases for database 'mail'. No entry
> found with that name. Make sure that the name is entered correctly.
>
> Please help, thanks
> Prem
Navigation:
[Reply to this message]
|