Location : Mysore (Karnataka) Experience : 2 - 4 Years Skills Required: - Coding Stored Procedures, Functions etc. - Debugging and Tuning - Database Design ...
5000
Satya
hisatya
Feb 11, 2007 5:04 pm
Hi group - My be this is old stuff and common issue for most of you but I have a issue in replication..I never worked on merged replication. here are the...
5001
Satya
hisatya
Feb 11, 2007 5:17 pm
I forgot to mention...it's SQL Server 2000 EE. Let me know if you need any further details. -S Satya <hisatya@...> wrote: Hi group - My be this is old...
5002
sunil john
suniljk7
Feb 12, 2007 1:03 pm
Dear all, I have a trigger on a table which will update some columns of another table upon any insert or update on the first table. Before updating the second...
5003
mohan mareboina
govinda_junior
Feb 12, 2007 5:43 pm
You can not do it as online operation. Users should need downtime to complete this operation. Regards, Jacks...
5004
mohan mareboina
govinda_junior
Feb 12, 2007 5:44 pm
As per my understanding DHCP should be part of domain. Why workgroup is in place? As per my understanding it may not have impact in a work group environment. ...
5005
mohan mareboina
govinda_junior
Feb 12, 2007 5:47 pm
You may not connect to SQL2k5 analysis server using SQL2k as client. Regards, Jacks...
5006
Mubarak Sha Mustaq Ah...
mubaraksha
Feb 13, 2007 4:55 am
My new server dosen't have domain controller. IT's workgroup. How can i connect the server from client via VISUAL STUDIO 2005? Thanks.. ... ...
5007
Ramesh Karnati
karnati_in
Feb 13, 2007 2:03 pm
Hello Sunil, With the piece of code you have provided, I think this can be done in much more simpler way. Try the following code and you may need to tweak a...
5008
nic_santosh
Feb 14, 2007 9:24 am
hi all, how to find the number of words present in a notepad(.txt file) using SQL ?? with regards s.santosh...
5009
sajesh gopal
sajeshgopal
Feb 14, 2007 6:08 pm
Hi, You can have DHCP Service running on a SQL 2005 box, there is no conflict as far as the installation goes. Ensure you provide a static IP to this server...
5010
sajesh gopal
sajeshgopal
Feb 14, 2007 6:40 pm
Hi Satya, You must restore Distribution database first, followed by MSDB, Publication database (the DB which is used in Replication) and finally any...
5011
Deepak Garg
deepakgrg
Feb 15, 2007 10:33 am
Hi guys, i need to migrate one MySQL server to MSSQL. can any one help me please ? its Urgent... Many Thanks, Deepak ... Expecting? Get great news right away...
5012
Madhu K Nair
madhuotp
Feb 15, 2007 1:20 pm
I have done a small project which was having 10-12 tables in MySQL ... What i did was i just configured linked server to Mysql from SQL Server, brought the...
5013
hisatya
Feb 16, 2007 1:11 am
Thanks Sajesh. You got my requirement right and this option really helps. I also told the users to make minimal or no changes at the subscriber while the...
5014
nic_santosh
Feb 16, 2007 5:43 am
Hi All, Assume that i have two SqlServer as Srv1 & Srv2 And Having databases As Follows. Srv1 ... database1 table1 table2 databaset2 table3 table4 Srv2 ... ...
5015
Madhu K Nair
madhuotp
Feb 16, 2007 7:06 am
There are many ways to do this.... (a) Configure LinkedServer in SVR1 to connect to SVR2 (b) OPENDATASOURCE Query (c) OpenQuery Madhu ... databases...
5016
mohan mareboina
govinda_junior
Feb 16, 2007 7:18 am
Hi Guys, I knew this is not right mail to publish in this forum. But it can help your friends/relatives to get a challenging job in the largest Indian IT ...
5017
nic_santosh
Feb 16, 2007 8:09 am
Hi Madhu, Thx.Assume that Srv1 is SqlServer and Srv2 is MySQL. Can u Give any Suggestion in this Stituation? Best Regards S.Santosh...
5018
Madhu K Nair
madhuotp
Feb 16, 2007 9:10 am
Refer this Link http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx Madhu...
5019
Madhu K Nair
madhuotp
Feb 16, 2007 9:16 am
These are the ways to Heterogeneous Data Access from MS SQL SErver... whether it is Excel,Oracle,Access,MySQL ..... Madhu ... and...
5020
nic_santosh
Feb 16, 2007 9:46 am
Hi Madhu & All, What Should be the steps to follow to acess data from mysql to mssql. For Further Clarification refer the same mail as below. With Regards ...
5021
Madhu K Nair
madhuotp
Feb 18, 2007 6:52 am
hi santosh, Configure Linkedserver in SVR1 to connect to SVr2(MYSQL)... Refer Configure LinkedServer in BOL ...(system storedprocedure to configure...
5023
Madhu K Nair
madhuotp
Feb 20, 2007 5:34 am
SQL Server 2005 SP2 and a new version of the 2005 Books Online Released and now available at SQL Server 2005 Service Pack 2: ...
5024
Madhu K Nair
madhuotp
Feb 20, 2007 6:31 am
list of Bugs fixed http://support.microsoft.com/?kbid=921896 ... bc8f-...
5025
Mariam John
mariam_john889
Feb 22, 2007 10:43 am
Bill Gates thinks Google should be worried! ... You must have heard by now about Agloco and how many people think it is going to be bigger than Google... Now...
5026
mohd rizwan
mo2riz
Feb 23, 2007 3:48 pm
Hi Friends, How can we know about the date of index creation? Is this possible? Thanks & Regards, Mohd Rizwan (¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep ...
5027
Chakradhar Kopalle
DAMAKARUDU
Feb 23, 2007 6:41 pm
Hi Rizwan I sincerely admit that I do not know how to accomplish this, but a simple management technique, note the date and time of creation manually.......
5029
Roji. P. Thomas
roji_pt
Feb 24, 2007 9:14 am
Madhu, 1. sysobjects does not contain information about indexes. 2. As of today, there is no way to find the created date of an index in SQL server. That said,...
5030
Madhu K Nair
madhuotp
Feb 24, 2007 1:46 pm
Hi Roji, I posted it without trying myself... after posting in forum i checked... i realised the mistake and I deleted my post... in the meantime you have...
