Google https://www.google.co.in/?gws_rd=cr&ei=1C48UtDrAs7KrAfnyoDwAQ#q=database+migration+in+Sql+server

Have you tried to do the INSERT with Clustered...

Preethi S Raj (9/20/2013)

---

SQL Server automatically adds the partition column to a secondary nonunique index as an included column if the CREATE INDEX statement does not already contain the partition...

see this http://sqldbpool.com/2011/09/28/useful-queries-while-troubleshooting-database-mirroring/

Is it necessary to make it offline can we make it single user and then then do the rest of steps...

YOu need to go with batch approach where...

SrcName (9/20/2013)

---

use truncate statement. it has many adventages

Because truncate has not where clause and you need some data, then you can save them in another temp table, truncate base table...

How did your figure it out ?

can you post complete Error with error state ?

See below

ERROR STATE ERROR DESCRIPTION

------------------------------------------------------------------------------

2 and 5 ...

In this case There is...

anoop.mig29 (9/19/2013)

---

Hi i am trying to send database mail and using gmail as an smtp server.i have used my emailid,and password for credentials.port use is either 587 or 456.but i...

NO both are different .

Rollback then raise error, then error will not raise but vice versa will raise the rerror.

see

begin try

begin tran

select 1/0 as result

commit

end...

51 views ( last including mine) but NO response and the reason is :

No sample data

NO business rule or logic

NO table definition on this post.

Include them and...

Create Maintenance Plan >> Maintenance Cleanup Task >> Delete specfic file >> Delete Older file older tha 1 month

Also place table definition plus some sample data.