Viewing 15 posts - 1,141 through 1,155 (of 1,179 total)
I have not much exposure of VMWare.
But if we think logically I won't perfer to run production on VMWare on follwoing ground:
1. It will share the resources like CPU,...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 31, 2008 at 12:36 am
Hello Paul,
FYI:
I was using sql server 7.0 standard edition RAM 2.0 GB. Memory setting Dynamic. Now we have upgraded the server to 4.0 GB.
After the memory upgrade the problem...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 31, 2008 at 12:21 am
Looks like memory leak problem:
refer the sql server and do the AWE settings as per the articles
http://support.microsoft.com/kb/274750
Make sure you are using sql server enterprise edition; else assign sql server to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 11:41 pm
You can design DTS package (SSIS) to do insert / delete operation and schedule DTS package.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 6:56 am
In my openion both command do the same thing one shrinkfile will shrink single file while shrinkdatabase will shrink the set of files in the database. Also after executing any...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 6:53 am
Microsoft itself is using Lightspeed to backup their VLDB databases. Hence I won't hesitate to go with Lightspeed.
But if you are looking something more beyond only Backup/Restore and to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 6:18 am
What is the database size? Make sure you do have enough space for the backup. Generally once backup starts will completed successfully.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 6:05 am
Workaround:
You can use SSIS and transfer table from SQL Server 2000 to SQL Server 2005 instead of text file.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 4:07 am
I also face the similar kind of problem:
When the table size is very small and contain a few rows only at that time this kind of problem happen. In addition...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 30, 2008 at 12:05 am
As you do have 2 objects dbo. authors and user.authors with same name like authors you can't change irrespective of database owner you can't change the ownership.
There is a trick:
1....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 29, 2008 at 11:48 pm
check the credential for user 'Corporate\GeorgeW' he must be member of database role db_owner for the perticular database. Grant permission and try.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 29, 2008 at 11:25 pm
As far as I know we can't put database to comp. lev. 90 straightawy after the upgradation. You need to work on all the stored procedures in comp. lev. 90;...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 22, 2008 at 3:31 am
Check Microsoft following website for detail:
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2008 at 4:55 am
Thanks for the correction Minaz. It's DML trigger.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2008 at 3:36 am
You can try DATABASE MAIL instead of SQL Mail in SQL Server 2005. I guess DATABASE MAIL is more reliable than SQL Mail.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2008 at 3:22 am
Viewing 15 posts - 1,141 through 1,155 (of 1,179 total)