Issue after copying data - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Issue after copying data

Message

De

30/11/2010 14:18:17

Sergey Berezniker
New York, États-Unis

À

30/11/2010 14:14:17

Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Scripting

Titre:

Re: Issue after copying data

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01491153

Message ID:

01491160

Vues:

56

The sp_MSforeachtable can help http://weblogs.asp.net/nunogomes/archive/2008/08/19/sql-server-undocumented-stored-procedure-sp-msforeachtable.aspx

>That's currently my workaround, but I have to issue that for every table in the DB.
>
>Basically I want a magic script that does everything I want it to do quick and easily. :-)
>
>>Another option is DBCC CHECKIDENT

--sb--

Click here to load this message in the networking platform