Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Issue after copying data
Message
From
30/11/2010 14:18:17
Sergey Berezniker
New York, United States
 
 
To
30/11/2010 14:14:17
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Title:
Re: Issue after copying data
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01491153
Message ID:
01491160
Views:
55
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform