Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

new DB?

Status
Not open for further replies.
nowayout

nowayout

Programmer
Feb 25, 2003
364
US
Hi all,

I am getting weird message in SQL Logs.. When i start new Database it gives me lot of message of starting up database 'Test' and it gives me continueslly,,, Why is it like this?

Thanks,,,
 
Sort by date Sort by votes
Your database is set to auto close. Run:
Code: 
alter database test
(set auto_close off)
go
This will stop it from unloading the database each time all users log off of the database.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
228
fredericofonseca
fredericofonseca
tekpr00
  • Locked
  • Question
Hello I am new to a new organizatio
Replies
1
Views
124
johnherman
johnherman
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
157
intel233
intel233
grnzbra
  • Locked
  • Question
Installing new Provider 1
Replies
2
Views
141
grnzbra
grnzbra
SamBones
  • Locked
  • Question
Moving a SQL Server DB Server
Replies
1
Views
140
SamBones
SamBones

Part and Inventory Search

Sponsor

Back
Top