Viewing 15 posts - 871 through 885 (of 1,179 total)
Hello Zombi,
Thank you for more clarification and making your question understand 🙂
As far as I know there should not be any problem unless and untill you are using ENGLISH language...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 25, 2009 at 11:45 pm
Zombi,
Here is the link for your reference:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
If you are successfully migrating... make sure to run DBCC commands to check data consistancy and Rebuild the indexes.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 24, 2009 at 12:08 am
you can go for option 2. 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 19, 2009 at 2:00 am
Just install SP2 straightaway.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 17, 2009 at 4:56 am
Granting read permission to Public role will be easiest way. 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 17, 2009 at 4:54 am
Which you have observed is absolutely normal.
You can also keep the database into Read_Only mode if while restoring full database you have kept that option. i.e. with STANDBY Option but...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 17, 2009 at 2:33 am
Yes it's possible to snapshot large database but your hardware should be sufficient enough to support it. There will be load on Distributor server as Snapshot and Distributor Agents are...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 17, 2009 at 2:26 am
This is something really interesting.
Can you pl. check with the other backup or check the latest backup for confirmation and compare the datetime.
One possiblilit will be make sure manually file...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 17, 2009 at 2:15 am
You can opt for MCTS / MCTP 2005. Well if you are doing dba course from better to do it with good faculty and reputed institute with may help you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 10, 2009 at 6:34 am
Duplicate post. Kinldy delete it.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 10, 2009 at 6:20 am
Your scenario is not exactly clear.
But yes Replication can be setup into hetrogenious environment.
Reference Link: http://msdn.microsoft.com/en-us/library/ms151835(SQL.90).aspx
Also if you would like to send output of a query to ORCALE; you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 10, 2009 at 6:18 am
Your database default collation is: SQL_Latin1_General_CP1_CI_AS
Hence when you are doing Alter table second time it's taking again database default.
I guess you can do it with SSMS with lot ease.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 10, 2009 at 6:06 am
It's advisable to keep backup.
Also if you are in developmet you need to keep the backup of your SP. Or you can generate the script of the SP and...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 6, 2009 at 6:38 am
In addition to the Paul; also you can create the table without any constraint and Primary Key will improve the performance. Later you can create the Primary Key or constraints.
In...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 6, 2009 at 6:31 am
use xp_cmdshell
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 6, 2009 at 6:17 am
Viewing 15 posts - 871 through 885 (of 1,179 total)