Viewing 15 posts - 1,216 through 1,230 (of 1,654 total)
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...
[font="Verdana"]Markus Bohse[/font]
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
[font="Verdana"]Markus Bohse[/font]
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:
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
August 23, 2007 at 5:56 am
Just enter the local computername as domain. That should work.
Markus
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
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
[font="Verdana"]Markus Bohse[/font]
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
[font="Verdana"]Markus Bohse[/font]
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....
[font="Verdana"]Markus Bohse[/font]
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...
[font="Verdana"]Markus Bohse[/font]
August 15, 2007 at 7:26 am
By short the answer should be NO.
There's no posibility to assign certain tasks to a dedicated CPU. The one exception I know about is if your running SQL Server Enterprise on a Windows...
[font="Verdana"]Markus Bohse[/font]
August 15, 2007 at 7:17 am
Viewing 15 posts - 1,216 through 1,230 (of 1,654 total)