[dba-SQLServer]Upsizing just the FE

Run Profiler and save output to a file.  There will be a lot of copy/paste operations, but you'll have everything right there.

Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
? (210) 913-3148 - phone
? (210) 753-3148 - pager

 -----Original Message-----
From: 	John W. Colby [mailto:jcolby at colbyconsulting.com] 
Sent:	Wednesday, March 26, 2003 1:14 PM
To:	dba-sqlserver at databaseadvisors.com
Subject:	[dba-SQLServer]Upsizing just the FE

Is there a way to upsize just the FE?  IOW, convert the queries for the
objects such as combos and forms to parameterized stored procedures?  Any
wizards to assist in that?

I did not save my SQL strings in my forms and combos etc to saved queries,
in fact I upsized the BE directly.  I am now trying to upsize the FE and
what PITA that is!  There are probably over a hundred queries just in the
combos and forms, never mind built up on the fly.  I am nowhere close to
fluent enough in the SQL syntax used in SQL Server to just type them back in
into stored procedures, complete with parameters.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

----------------------------------------------------
Is email taking over your day?  Manage your time with eMailBoss.
Try it free!  http://www.eMailBoss.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com