hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution2 2244
does physical index sort data1 1993
what type of indexes physically sort data?3 4183
How to store pdf file in sql server?1 4546
What is difference between stored procedure & function?3 4263
please 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 on1 1634
create 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 year3 2216
how to use DTS package in 2000,2005,2008 in sql server
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
what is isolation level at dead lock?
how many no of arguments can be passed in procedures and functions
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
sql database suspect We have a sql database that is showing as suspect. How can we recover?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
what is the sql equivaent of the dataset relation object ?
wat wil hapn if we give the both read and deny read permission to user?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is RMS migrations?
What is Lock table in SQL?
Does any body please help me what question's have asked for SSRS in the interview?
Working with TLogs