Hi,

You will have the follow the same sequence of restore as per the backup sequence. Skipping a TL-Log backup in between will report an error stating that...

Hi,

Its better to change the owner of database and then drop the login account which is not required. Use sp_changedbowner stored proc to change the db owner...

You can use ROW_NUMBER() function which will provide rankings for data based on columns. Use row_number() on Hotel_id column.No need of adding new column. check this query

SELECT hotel_id ,hotel_name +...

You cannot use 'select * into #temp from exec SPname'.

You will have to create the temp table first and then use insert statement with execute SP to add the result...

Before posting any question please provide the details of the table and data and then the query. Just specifying that query is running differently will not help us in finding...

You should use MS excel 2007 version or higher to support 1,00,000 rows. Since Ms excel 2003 has the limit of 65536 rows by 256 columns.

In excel 2007 the limit...

you can directly drop the stored proc using 'Drop proc procedurename' statement. Then the stored proc entry will be automatically be removed in sys.objects. It is not recommended to delete...

Yes.. howard is right. you cannot restore database backup from higher version to lower version. We have faced this issue many times.

Only option is to script the whole database.Then import...

You can use @@rowcount function to capture the no. of rows affected for the query executed.

Thanks,

Amit Kulkarni

You can use dynamic sql query

declare @ID varchar(max)

declare @sql nvarchar(4000)

set @sql = 'Select * from tblProduct

WHERE tbl_PRIM_Sales.Sale_ID in (' +@ID + ')'

sp_executesql @sql

Or you can insert all IDs in...

It cannot be possible that query will miss some of records. I suppose there is some problem with the query in the view. May be the where condition for filtering...

You can create indexed views in sql server 2008 Express edition

There is no direct way of finding the creation date of an index. But however if you look in sysobjects there is a creation date for Primary Key or Unique...

consider table Product

ProductID Quantity

A 10.25

B ...

can you please provide the details of the table like no. of columns and no.of records. Also there may be transaction open which might be holding a lock on the...