Francisco Tapia
fhtapia at gmail.com
Wed Jan 14 15:54:36 CST 2009
Susan, Did you ever get this resolved? -Francisco http://sqlthis.blogspot.com | Tsql and More... On Tue, Jan 13, 2009 at 1:23 PM, Susan Harkins <ssharkins at gmail.com> wrote: > Don't worry about it Martin -- it's my problem -- I'm sure I'm just > expecting the wrong thing. > > Susan H. > > > > Susan > > > > Sorry I am in the middle of AR on the new book. If you need this working > I > > can check it in the morning in work on another server with Adventure > works > > installed. Can spend a while on it then. > > > > Martin > > > > > > Martin WP Reid > > Information Services > > Queen's University > > Riddel Hall > > 185 Stranmillis Road > > Belfast > > BT9 5EE > > Tel : 02890974465 > > Email : mwp.reid at qub.ac.uk > > ________________________________________ > > From: dba-sqlserver-bounces at databaseadvisors.com > > [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins > > [ssharkins at gmail.com] > > Sent: 13 January 2009 21:12 > > To: Discussion concerning MS SQL Server > > Subject: Re: [dba-SQLServer] NEVERMIND (Fw: executing systemstored > > procedure) > > > > Most examples work -- the DELETE FROM ? that I've been trying doesn't > > return > > a result of course, just the Message tab that it's been completed > > successfully. > > > > Susan H. > > > > > >> Are you clicking the results tab? > >> > >> Martin > >> > >> > >> Martin WP Reid > >> Information Services > >> Queen's University > >> Riddel Hall > >> 185 Stranmillis Road > >> Belfast > >> BT9 5EE > >> Tel : 02890974465 > >> Email : mwp.reid at qub.ac.uk > >> ________________________________________ > >> From: dba-sqlserver-bounces at databaseadvisors.com > >> [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins > >> [ssharkins at gmail.com] > >> Sent: 13 January 2009 21:03 > >> To: Discussion concerning MS SQL Server > >> Subject: Re: [dba-SQLServer] NEVERMIND (Fw: executing systemstored > >> procedure) > >> > >> Okay, a little more experimenting and here's what's interesting. > >> > >> Mystery #1: When running against AdventureWorks, I have to use > >> master..sp_ > >> syntax, but others recognize sys.sp_ syntax. > >> Mystery #2: Even when using master..sp_ against AdventureWorks, it > >> recognizes the sp, but doesn't actually run it -- I get a message that > >> it's > >> been successfully completed, but it hasn't actually done a thing. > >> > >> Susan H. > >> > >> > >> > >> ----- Original Message ----- > >> From: "Martin Reid" <mwp.reid at qub.ac.uk> > >> To: "Discussion concerning MS SQL Server" > >> <dba-sqlserver at databaseadvisors.com> > >> Sent: Tuesday, January 13, 2009 3:50 PM > >> Subject: Re: [dba-SQLServer] NEVERMIND (Fw: executing systemstored > >> procedure) > >> > >> > >>> Susan > >>> > >>> I ran it just there and it worked fine here I changed the database to a > >>> copy I have here and it worked fine. > >>> > >>> [dbo].[Customers] 29 > >>> [dbo].[Employee Privileges] 1 > >>> [dbo].[Employees] 9 > >>> [dbo].[Inventory Transaction Types] 4 > >>> [dbo].[Inventory Transactions] 102 > >>> > >>> use NWind > >>> go > >>> create table #rowcount (tablename varchar(128), rowcnt int) > >>> exec sp_MSforeachtable > >>> 'insert into #rowcount select ''?'', count(*) from ?' > >>> select top 5 * from #rowcount > >>> order by tablename > >>> drop table #rowcount > >>> > >>> > >>> Martin > >>> > >>> > >>> Martin WP Reid > >>> Information Services > >>> Queen's University > >>> Riddel Hall > >>> 185 Stranmillis Road > >>> Belfast > >>> BT9 5EE > >>> Tel : 02890974465 > >>> Email : mwp.reid at qub.ac.uk > >>> ________________________________________ > >>> From: dba-sqlserver-bounces at databaseadvisors.com > >>> [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan > Harkins > >>> [ssharkins at gmail.com] > >>> Sent: 13 January 2009 20:38 > >>> To: Discussion concerning MS SQL Server > >>> Subject: Re: [dba-SQLServer] NEVERMIND (Fw: executing system stored > >>> procedure) > >>> > >>> I've tried several examples now -- they run, but they don't actually > >>> return > >>> anything -- this one creates the table, but doesn't fill it. > >>> > >>> Susan H. > >>> > >>> > >>>> Try this > >>>> > >>>> Just lifted it of the web > >>>> > >>>> use pubs > >>>> go > >>>> create table #rowcount (tablename varchar(128), rowcnt int) > >>>> exec sp_MSforeachtable > >>>> 'insert into #rowcount select ''?'', count(*) from ?' > >>>> select top 5 * from #rowcount > >>>> order by tablename > >>>> drop table #rowcount > >>> > >>> _______________________________________________ > >>> dba-SQLServer mailing list > >>> dba-SQLServer at databaseadvisors.com > >>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >>> http://www.databaseadvisors.com > >>> > >>> _______________________________________________ > >>> dba-SQLServer mailing list > >>> dba-SQLServer at databaseadvisors.com > >>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >>> http://www.databaseadvisors.com > >>> > >> > >> _______________________________________________ > >> dba-SQLServer mailing list > >> dba-SQLServer at databaseadvisors.com > >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >> http://www.databaseadvisors.com > >> _______________________________________________ > >> dba-SQLServer mailing list > >> dba-SQLServer at databaseadvisors.com > >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >> http://www.databaseadvisors.com > >> > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >