hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
2 4509How to store pdf file in sql server?
CarrizalSoft Technologies, College School Exams Tests, TATA,
1 7060please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
1 3519create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
3 5190
what are the reporting service components in SSRS?
How do you handle datasets larger than 50 gb?
What is database replication? What are the different types of replication you can set up in sql server?
How to view existing indexes on an given table using sys.indexes?
What is a fill factor?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is the use of sign function?
Explain transaction server consistency?
what type of index will get created after executing the above statement? : Sql server database administration
What is the difference between for xml raw and for xml auto?
What is the use of keyword with encryption.
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Do you know the capabilities of cursors?
How many types of objects are there?