Viewing 15 posts - 1,216 through 1,230 (of 1,655 total)
Carmen,
the most likely reason is that the databases which fail are in SIMPLE recovery mode. Either change it to FULL or exclude them from the transaction log backup.
Markus
August 28, 2007 at 12:39 am
Question 1:
One or two maintenance plans, I would say if you're not on SP2 you won't have much choice other than two plans. After SP2 you can create several...
August 27, 2007 at 8:08 am
Ahmed,
maybe it would help if you told us what type of order you mean. WHich field you want to be ordered ? Maybe some sample output would help.
Markus
August 27, 2007 at 3:22 am
Anbu,
as far as I know it's not possible to query this in SQL 2000. In 2005 you can use the DMV sys.dm_db_session_space_usage. Something like the following should work:
August 24, 2007 at 6:26 am
You posted your question in the 2005 Administering group so I assumed you're looking for a 2005 solution. In 2000 you need to query the syspermissions table.
Or what I usually...
August 23, 2007 at 7:02 am
Not sure if this is what you want, but this will give you all permissions granted to any userrole, user or public within a database. In order to get the...
August 23, 2007 at 5:56 am
Just enter the local computername as domain. That should work.
Markus
August 23, 2007 at 5:31 am
Anton,
are you sure you stopped the right service? I never had any issues like this. The service for 2005 is called "SQL Server (MSSQL Server)" versus "MSSQLSERVER" in 2000.
Are...
August 23, 2007 at 5:28 am
Chris,
the offical recommendation of MS is no more than 10 databases per instance. http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
BOL says the same, but only for 32-bit servers, but I don't think that 64-bit...
August 21, 2007 at 1:55 am
Anil,
just as the pop-up message said, you cannot install the server on windows XP which is a desktop OS. Either use Personal Edition or Developer Edition. These are the only...
August 17, 2007 at 3:05 am
Mark,
in SQL 2005 the tempDb is used a lot more than in SQL2000 depending on some options like Snapshot Isolation level. For more see here: http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
If you have performance...
August 16, 2007 at 7:11 am
Once you have installed an instance of SQL 2005 you can add new instances or features from Control Panel Add\Remove Programs.
Markus
August 16, 2007 at 4:30 am
Sorry,
I don't think I can help you but I'm curious why you're saying that SERVERPROPERTY doesn't always return the correct information. Do you have examples of that /
Markus
August 16, 2007 at 4:24 am
Sorry Steve,
but i don't have a reference for this. Some time ago I visited a session at Unisiys where they did some benchmark test on a ES7000 with Datacentr installed....
August 15, 2007 at 10:43 am
Rohit,
the problem seems to be that your trigger can't handle the update of several records at once. This is a common problem when people start using triggers. If you post the...
August 15, 2007 at 7:26 am
Viewing 15 posts - 1,216 through 1,230 (of 1,655 total)