Viewing 15 posts - 1 through 15 (of 34 total)
Definately, AutoClose is the reason.
The entries that you see are when the Offline database is brought online i.e. when the recovery is being performed on the database.
It would not cause...
March 19, 2007 at 6:44 am
Not sure if you already did this, but please check the MSDE errorlog to see if the instance is listning on TCP/IP.
March 19, 2007 at 6:29 am
Hello,
The errors that you are getting are SQL server assertions. This means there are some internal checks in the SQL server software for which the result should always be true...
March 19, 2007 at 6:22 am
Do you hav a clustered index on the table ?
If yes, then you can rebuild that index and should solve the problem.
If not create a clustered index.
March 19, 2007 at 6:09 am
it isint as complicated as it seems.
just make any other login the owner of the database
use dbaname
sp_changedbowner 'sa'
then you should be able to delete the user sucessfully
February 21, 2007 at 7:26 am
It seems that our Dear Friend Frank is frustated with the Microsoft Products.
Well, I would always prefer SQL server SP installation over that of...
February 21, 2007 at 7:11 am
Yes, thats right. It wont really impact the performance except that your errorlog will get much fuller depending on the numner of logins.
If you enable the C2 auditing, there will...
February 21, 2007 at 6:30 am
I dont think Empty space is the reason. Empty space would mean the the actual file size should be bigger than a backup. but here it is other way round....
February 21, 2007 at 6:25 am
Sam, ithink you are entering the Machine name. the name to be entered should be the virtual server name for the windows cluster that you have created already.
February 21, 2007 at 5:14 am
The soultion is in the error itself. try to read and understand the error before posting it on the forum.
February 20, 2007 at 9:21 am
The only way to troubleshoot deadlock will be to see the deadlock graph, to get those you need to enable the traceflags (1205 and 3604, i believe). This will dump...
February 20, 2007 at 9:11 am
the only things affected would be the windows logins (if you do not have trust relationship between the domains). Hence just dropping and recreating the windows logins should be the...
February 20, 2007 at 9:06 am
There is no patch to be applied to the SQL server, because SQL server relies on the O.S. timmings. Hence the OS patch is sufficient .
See below article that would...
February 20, 2007 at 8:59 am
If you replication, I suggest not to use the same master databases. YOu just never know when in future your replication fails !!!!!!!
I would suggest to create a new...
February 20, 2007 at 8:55 am
I agree with Markus and stand by my statement --
you cannot cluster 2 nodes -- one having 32 bit OS and otehr having 64 bit OS
February 20, 2007 at 8:34 am
Viewing 15 posts - 1 through 15 (of 34 total)