hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution2 2310
does physical index sort data1 2070
what type of indexes physically sort data?3 4292
How to store pdf file in sql server?1 4611
What is difference between stored procedure & function?3 4352
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 1701
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 2300
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is best institute to Learn DotNET And SQL in chennai?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
SQL Server Architecture ?
What are the dis_advantages of stored procedures, triggers, indexes?
If user is owning any SQL Objects, can we drop that user
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
application server is slow what may be the problem
How much memory that we are using in Logshipping Concept?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
what is package and it uses and how can u call a package
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?