Mssql

create table ename (cid bigint,cname varchar(20),yoe bigint,domain varchar(20),special varchar(20),location varchar(20),age bigint,rsta varchar(20),percentage bigint,record varchar(20))

select cid,cname,yoe,domain,special from ename where (cid=23 and cname='Tamil' and yoe=2 and domain ='it' and special='computer' and location='chennai' and record='dotnet') or (age='' and rsta='' and percentage='')

Quote:

Originally Posted by thamilarasangc

create table ename (cid bigint,cname varchar(20),yoe bigint,domain varchar(20),special varchar(20),location varchar(20),age bigint,rsta varchar(20),percentage bigint,record varchar(20))

select cid,cname,yoe,domain,special from ename where (cid=23 and cname='Tamil' and yoe=2 and domain ='it' and special='computer' and location='chennai' and record='dotnet') or (age='' and rsta='' and percentage='')

create table ename (cid bigint,cname varchar(20),yoe bigint,domain varchar(20),special varchar(20),location varchar(20),age bigint,rsta varchar(20),percentage bigint,record varchar(20))

select cid,cname,yoe,domain,special from ename where ((cid=23 and cname='Tamil' and yoe=2 and domain ='it' and special='computer' and location='chennai' and record='dotnet') or (age='' or rsta='' or percentage=''))

Msg 3710, Level 16, State 1, Line 1

Hello Folks,

I am moving the model & Msdb databases to a different location and I have this error.

Thanks

Msg 3710, Level 16, State 1, Line 1

Cannot detach an opened database when the server is in minimally configured mode.

I was able to fix it, I used an ALTER DATABASE statement.

Thanks for the time.

|||What command are you using...the Alter DB stmt only works with TEMPDB...I thought? I am getting "

Cannot detach an opened database when the server is in minimally configured mode." as well. I set the trace flag -T3608 and I get the message when I exec sp_detach_db 'msdb'

|||I was able to resolve this error by restarting SQL Server

Msg 3710, Level 16, State 1, Line 1

Hello Folks,

I am moving the model & Msdb databases to a different location and I have this error.

Thanks

Msg 3710, Level 16, State 1, Line 1

Cannot detach an opened database when the server is in minimally configured mode.

I was able to fix it, I used an ALTER DATABASE statement.

Thanks for the time.

|||What command are you using...the Alter DB stmt only works with TEMPDB...I thought? I am getting "

Cannot detach an opened database when the server is in minimally configured mode." as well. I set the trace flag -T3608 and I get the message when I exec sp_detach_db 'msdb'

|||I was able to resolve this error by restarting SQL Server
|||Mkae sure to set the SQL server Service to Automatic mode and restart the SQL Server Service resolved my problem.

Msg (Loading) after db name

I wanted to restore a database to a new location on a different server. I
did a backup to a file and then did a restore of that file onto the new
server. I got a message that the restore was successful, but when I opened
Enterprise Manager the database had "(Loading)" after the database name and
was grayed out. When I tried to select properties it gave me "Error 927:
Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
Can anyone help? Thanks.
DavidSounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>|||Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>

Msg (Loading) after db name

I wanted to restore a database to a new location on a different server. I
did a backup to a file and then did a restore of that file onto the new
server. I got a message that the restore was successful, but when I opened
Enterprise Manager the database had "(Loading)" after the database name and
was grayed out. When I tried to select properties it gave me "Error 927:
Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
Can anyone help? Thanks.
David
Sounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>
|||Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>
|||Yup. That was it...had the "Leave database nonoperation..." radio boxed
checked. Thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Msg (Loading) after db name

I wanted to restore a database to a new location on a different server. I
did a backup to a file and then did a restore of that file onto the new
server. I got a message that the restore was successful, but when I opened
Enterprise Manager the database had "(Loading)" after the database name and
was grayed out. When I tried to select properties it gave me "Error 927:
Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
Can anyone help? Thanks.
DavidSounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>|||Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>|||Yup. That was it...had the "Leave database nonoperation..." radio boxed
checked. Thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!