Viewing 15 posts - 76 through 90 (of 92 total)
If you really want to delete records from Table B, C, D & E after records on Table A are deleted; then you can define foreign key relations with ON...
January 29, 2010 at 12:04 am
IC,
Is your database names you are mirroring on both the servers are alike? I had this issue before and everything from n/w side was OK, then I realised that names...
January 28, 2010 at 2:30 am
I knew these datatypes were not in SQL versions prior to 2000 and they are in 2008, but thought they might have included in 2005...i was wrong...:-D
January 28, 2010 at 1:52 am
Know everything about replication links below:
http://msdn.microsoft.com/en-us/library/ms151314.aspx
Look at Replication Wizard...
You can very well setup/delete replication using scripts. Easiest way to get this script is setup replication using wizard and...
January 27, 2010 at 11:47 pm
Thanks vstitte and Jason
January 27, 2010 at 10:43 pm
nageshreddy_p (1/27/2010)
2) You can install 2000 and 2005 with different instance names.
Can Default instance be of any version (2000/2005/2008) or is there any limitation like e.g only 2008 can be...
January 27, 2010 at 9:52 pm
Gr8 QotD, Thanks...I got it correct...but it was just a calculated guess...as other options were incorrect...
look fwd to use this wildcard...
January 26, 2010 at 10:20 pm
Only Insert, Update, Delete commands are traversed from Publisher to Subscriber
January 25, 2010 at 3:27 am
Good question..looking at few QotD last few days...Thanks
January 24, 2010 at 10:40 pm
I agree with Stewartc, In 2008 intial size for mdf is 3 MB and for ldf its 1 MB, so initial size of DB would be 4 MB and not...
January 20, 2010 at 10:14 pm
Why you want to upgrade/migrate system databases? Install SQL 2005 and upgrade/migrate your user databases.
January 5, 2010 at 5:52 am
I agree with Craig...so i guess non of the answer is correct
January 5, 2010 at 2:27 am
STOPAT with file with 0510 and 0520 is irrelevant...
January 5, 2010 at 2:14 am
Viewing 15 posts - 76 through 90 (of 92 total)