[dba-SQLServer] NEVERMIND (Fw: executing systemstored procedure)

Martin Reid mwp.reid at qub.ac.uk
Tue Jan 13 15:16:54 CST 2009


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



More information about the dba-SQLServer mailing list