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...

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

you can go for option 2. 🙂

Just install SP2 straightaway.

Granting read permission to Public role will be easiest way. 🙂

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...

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...

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...

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...

Duplicate post. Kinldy delete it.

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...

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

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...

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...

use xp_cmdshell