Stored Procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Stored Procedure

Author

Topic

Petronas
Posting Yak Master

134 Posts

Posted - 2009-02-23 : 17:05:27

Hi,

Please excuse the simplicity of this question as I am totally new to stored procedures.
I am trying to create a stored procedure, in_legacy_by_marketing_company_TEST.
After I execute it, it shows me Command(s) completed successfully.Though
this stored procedure is not showing up under Datamart (database) in the Object Explorer in
The SQL Management studio.

USE [Datamart]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [in_legacy_by_Marketing_Company_TEST]
@partner varchar(200) ,
@start_date datetime,
@end_Date datetime,
@p_product_id varchar(200),
@p_marketing_id varchar(200),
@p_marketing_company varchar(200),
@p_account_Status varchar(20)

AS
Set Transaction Isolation level read uncommitted

<SQL statement here>

Thanks for your help,
Petronas

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-23 : 17:08:51

Did you try refreshing?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Petronas
Posting Yak Master

134 Posts

Posted - 2009-02-24 : 09:32:49

Hi Tara,

Thanks..the refresh worked.

Thanks again for your help,
Petronas

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources