Trouble will connection string for 2014. Here is what I am using and I
am not connecting:
'{Sql Server Native Client 11.0}, Server=192.168.1.115,
Database=ABEL_PROD, Trusted Connection=Yes'
I think this may be for 2012 and doesn't work for 2014.
What is the connection string for 2014. It is not in connectionstrings.com
TIA
On 4/6/2015 6:41 AM, Stephen Russell wrote:
On Sun, Apr 5, 2015 at 6:12 PM, Ted Roche <[email protected]> wrote:
Matt's answer works.
Or you can use the VFP call SQLTables() to get a list of tables, then
loop through there, executing SELECT COUNT(*) FROM {tablename} to get
the record counts.
------------------------
This was eloquent:
EXEC sp_MSForEachTable @command1='INSERT #counts (table_name,
row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count
DESC
The SP_MSForEachTable is a strong sproc that will run the same command for
all tables. Insert the result into a working table and you are good to go.
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
