Hello ,i think that a problem is you forget to use if statement at first As follow this Rule

IF <CONDITION> BEING

IF <NEW CONDITION> BEGIN

...

For example:

USE AdventureWorks;

GO

BEGIN TRANSACTION;

BEGIN TRY

-- Generate a constraint violation error.

DELETE FROM Production.Product

WHERE ProductID = 980;

END TRY

BEGIN CATCH

...

Ok For more Details Show

http://www.databasejournal.com/features/mssql/article.php/3507171/Transferring-Data-from-One-Table-to-Another.htm

And

http://www.w3schools.com/SQL/sql_insert.asp

😎

Sorry But your Question ,As i thought something strange ,You want some one to just run a Query for you!

:w00t:

:hehe:

Sorry i forget also to post an Important post relate to your query

Configure each service used by SQL Server 2005 suite of products. Services include the relational database management service...

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_27073264.html

http://technet.microsoft.com/en-us/library/cc917563.aspx

Ok pls show m y below Link pls

ok check this link below

http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/[/url]

😉

First:

Operators and functions are either collation sensitive or insensitive.

Collation sensitive

This means that specifying a No-collation operand is a compile-time error. The expression result cannot be No-collation.

Collation insensitive

This means that...

So Koen Verbeeck

No not funny ,So Why i sent you link to View everything in Details ?!

What's the wrong of that !

Vc Quando estiver rolling or Upgrade advisor, connect-server is not com or Management Studio, open or execute a query editor and sp_who.

Veja is blocked there Conexão alguma (Coluna blk> 0)....

:hehe:

or use Use the Upsizing Wizard from office

see link for detals

http://office.microsoft.com/en-us/access-help/move-access-data-to-a-sql-server-database-by-using-the-upsizing-wizard-HA010275537.aspx

😛

Just to say ,Sumanta Roy say the same answer from my sound ;-);-) Thank you for your reply quick quick quicklyy

:hehe:

sorry see below link instead man

http://stackoverflow.com/questions/3296428/changing-sql-server-collation-to-case-insensitive-from-case-sensitive

see link elow for general triger info

http://msdn.microsoft.com/en-us/library/ms189799.aspx

😉

See this book from page 14

http://www.docstoc.com/docs/18484075/SQL-Server-Tacklebox-EBook