question

I have my sql error log filled with "starting up database
XPTO" but that database is fine (not suspect or
anything).. i thought it would be the users in the
database but the users that have permissions are all ok...
does anyone know why this is happening?You probably have autoclose for the database turned on.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"cs" <anonymous@.discussions.microsoft.com> wrote in message news:763c01c430e0$31d55a90$a101280a@.phx.gbl...
> I have my sql error log filled with "starting up database
> XPTO" but that database is fine (not suspect or
> anything).. i thought it would be the users in the
> database but the users that have permissions are all ok...
> does anyone know why this is happening?

question

Can anyone tell me why this gives me the following error:
declare @.hstname varchar (50)
set @.hstname = 'XPTO'
Select * from openquery (@.hstname,'select * from
master..sysdatabases')
Error:
Incorrect syntax near "@.hstname"From Books Online:
"OPENQUERY does not accept variables for its arguments."
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
":)" <anonymous@.discussions.microsoft.com> wrote in message news:33cc01c4291b$82c179b0$a301280a@.phx.gbl...
> Can anyone tell me why this gives me the following error:
> declare @.hstname varchar (50)
> set @.hstname = 'XPTO'
> Select * from openquery (@.hstname,'select * from
> master..sysdatabases')
> Error:
> Incorrect syntax near "@.hstname"