ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
If you are working on a SQL database and if suddenly a 
developer changes the code and your queries results start 
giving errors,how will you check using a T-SQL query (on 
system tables) that what has changed in the database.
 Question Submitted By :: Shalini
I also faced this Question!!     Rank Answer Posted By  
 
  Re: If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Answer
# 1		 
select text from sysindexes
 
Is This Answer Correct ?    0 Yes 0 No
Ramakrishna
 
  Re: If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Answer
# 2		 
SELECT   syscomments.text AS text
FROM         sysobjects INNER JOIN
                      syscomments ON sysobjects.id =
syscomments.id where  sysobjects.name=(stored procedure name)
 
Is This Answer Correct ?    1 Yes 0 No
Sumesh.tc
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the magic tables in SQL Server 2000? Infogain5
What is the appropriate number of test cases that you can write on a database? Microsoft1
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table. Techno-Solutions2
What's the difference between a primary key and a unique key?  4
what is a stored procedure and trigger?  1
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"  1
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
About DTS usage ? Cognizent2
how can i store resumes in database? HCL2
What is normalization and its forms? Challenger-Financial3
What are defaults? Is there a column to which a default can't be bound?  2
What are functions  3
Which system table contains information on constraints on all the tables created?  2
What is the datatype returned by count(*) Asian-CERC18
How would you Update the rows which are divisible by 10, given a set of numbers in column?  1
HOW TO RENAME A COLUMN NAME  2
Can Somebody tell me the difference between Clustered & Non- Clustered Index?? Progressive3
What are the different types of joins and what does each do?  2
Which virtual table does a trigger use?  3
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com