Hi all, what are the system tables and jobs used by replication ? Regards Rajesh
Hi All, I am posting some DBA Adminstration questions.I have tried alot to get answer for these questions, but they were out of my scope and...
Hi All, Where can i get help regarding this topic ??? "Recovery of data/database " - sql server 2000 Regards Rajesh
Hi All, How to disable a index using select query?? Regards Rajesh.
Hi All, How many no. of tables can be used inside a join. is there any maximum count. Regards Rajesh
Hi All, I need a sample tables which contain list of all the countries with appropriate states and wit happropraite cities. Where can i get this...
Hi all, What should we check after deploying the database from physical model. is there any articles or tutorials specifing these check lists....
Hi All, I had a scenario like ... I have a windows 2000 server OS with sql server 2000 installed. when i am creating instances from other system...
Hi All, How many ways are there to reset the identity value???? Regards Rajesh.
Hi all, can we have more than one ldf file for a database? Regards Rajesh.
Hi All, What is the maximum length a Stored Procedure name can be ???? Regards Rajesh.
Hi all, we can perform some queries like select * from sysobjects where xtype='tr' i want to know what are the other operations can be done on all...
Hi, i had some sub queries like select * from emp where empid not in (select distinct empid from dept) in this which will be execute first...
Hi all, what are the differences between cast and convert. Regards Rajesh.
Hi all, i created a separate column fro timestamp. now i want to get the last created or updated 20 records.... how can i get this.... regards...
Hi all, I had a scenario of using cursors, how to avoid that, is there any other alternative for avoiding cursors. My scenario: i had to get...
Hi All, How to get the space used by a perticular database in my server. Regards Rajesh.
Hi all, I have written a trigger on a table. It is working good . I want to edit the trigger now.... How can i do that... Regards Rajesh
Hi All THis is my query: declare @xmlstring varchar(7500) set @xmlstring ='<ROOT> <GRAPH StDt="2006-02-02" EndDt="2006-02-02" /> <GRAPH StDt=" "...
Hi all, we had a DB server. In that we installed SQL Server. And in all other mechines we done a client software. but the EM in client mechine is...
Separate names with a comma.
