Susan Harkins
ssharkins at gmail.com
Wed Jan 14 17:17:46 CST 2009
Not really, but I didn't work on it today at all. I'll try again tomorrow and see what happens. Susan H. > 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 >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >