Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting row count as part of DB design info
Message
From
05/02/2008 09:16:56
Naomi Nosonovsky
Wisconsin, United States
 
 
To
05/02/2008 09:08:48
Rollin Burr
SAIC
Stafford, Virginia, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Getting row count as part of DB design info
Miscellaneous
Thread ID:
01289085
Message ID:
01289494
Views:
14
>Hey Naomi,
>
>Is it posible, using the SP_MSForEachTable, to implement a distributed query (i.e. to select data from tables in DB1 while connected to DB2)? I have tried the syntax I thought would work (for a fully qualified table name substitution), but it did not work.
>
>>Rollin,
>>
>>Please check http://www.mssqlcity.com/Articles/KnowHow/RowCount.htm
>>
>>or
>>
>>http://www.databasejournal.com/features/mssql/article.php/3441031
>>
>>Look also to SP_MSForEachTable
>>

What exactly you're trying?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform