Issues related in upgrading SQL Server 2000 to 2005 / 2008

720

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

752

what is isolation level at dead lock?

968

How to convert a table data in XML format in sql server?

1351

query processing

956

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

797

how can u get last observation in an unknown dataset ?

1083

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.

2628

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

728

role of sql sever 2005 in database rather than any other database

834

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

848

how to overcome kernel isssues

436

If user is owning any SQL Objects, can we drop that user

812

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

817

sql database suspect We have a sql database that is showing as suspect. How can we recover?

671