MS SQL Server :: Rename A Stored Procedure In Server Management Studio

How Do I Create A Stored Procedure In SQL Server Management Studio Express?
I have wrriten many stored procedures in the past without issue, but this is my first time using SQL Server Management Studio Express. I am having trouble creating a new stored procedure. Here is what's happening:
I am opening my database, right clicking on "Stored Procedures" and selecting "New Stored Procedure". A new window opens with a template for creating a stored procedure. The window is called: "SQLEXPRESS.DBName - sqlquery1.sql". I then type up my stored procedure without an issue.
However, when I go to save the stored procedure it wants to save it as a separate file in a projects folder. It does not become part of the DB (as far as I can tell).
When I used to use Enterprise Manager (not an option anymore) this never happened.
I'm sure I'm doing something dumb. Can someone enlighten me.
Thanks,Chris

View Replies !

Attaching A Stored Procedure To A Database In MS SQL Server Management Studio
Hello all!

Quick question... I've created my DB in MSSQLSMS, then attempted to created a stored procedure for it. The code itself is fine, I just need to know how to actually attach it so that it appears in the "Stored Procedures" section of my Database.

I have Right Clicked on Stored Procedures > New Stored Procedure... > Edited as required > Save

When I attempt to save it, it prompts me for a file. That's fine, did that - but I can't see ANY way to actually attach this to the DB.

Any help is appreciated!

Daniel Davies

View Replies !

How To Empty A Stored Procedure In Ms Sql Server Management Studio Express
hi everyone,

I have a db based on the Tracking_Schema.sql / Tracking_Logic.sql (find in &windir%/Microsoft.NET/Framework/v3.0/Windows Workflow Foundation/SQL/EN), so after executing both of them I get several stored procedures, especially dbo.GetWorkflows. And I have a solution in VS05 which when executed is filling this stored procedure with Instance-Id´s. My question is: how is the working command (like exec, truncate,..) to empty my st.procedure, not to drop/delete it?

Thanks in advance, best regards

bg

View Replies !

Help: Why Excute A Stored Procedure Need To More 30 Seconds, But Direct Excute The Query Of This Procedure In Microsoft SQL Server Management Studio Under 1 Second
Hello to all,
I have a stored procedure. If i give this command exce ShortestPath 3418, '4125', 5 in a script and excute it. It takes more 30 seconds time to be excuted.
but i excute it with the same parameters direct in Microsoft SQL Server Management Studio , It takes only under 1 second time
I don't know why?
Maybe can somebody help me?
thanks in million
best Regards
Pinsha
My Procedure Codes are here:set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[ShortestPath] (@IDMember int, @IDOther varchar(1000),@Level int, @Path varchar(100) = null output )
AS
BEGIN

if ( @Level = 1)
begin
select @Path = convert(varchar(100),IDMember)
from wtcomValidRelationships
where wtcomValidRelationships.[IDMember]= @IDMember
and PATINDEX('%'+@IDOther+'%',(select RelationshipIDs from wtcomValidRelationships where IDMember = @IDMember) ) > 0
end
if (@Level = 2)
begin
select top 1 @Path = convert(varchar(100),A.IDMember)+'-'+convert(varchar(100),B.IDMember)
from wtcomValidRelationships as A, wtcomValidRelationships as B
where A.IDMember = @IDMember and charindex(convert(varchar(100),B.IDMember),A.RelationshipIDS) > 0
and PATINDEX('%'+@IDOther+'%',B.RelationshipIDs) > 0
end
if (@Level = 3)
begin
select top 1 @Path = convert(varchar(100),A.IDMember)+ '-'+convert(varchar(100),B.IDMember)+'-'+convert(varchar(100),C.IDMember)
from wtcomValidRelationships as A, wtcomValidRelationships as B, wtcomValidRelationships as C
where A.IDMember = @IDMember and charindex(convert(varchar(100),B.IDMember),A.RelationshipIDS) > 0
and charindex(convert(varchar(100),C.IDMember),B.RelationshipIDs) > 0 and PATINDEX('%'+@IDOther+'%',C.RelationshipIDs) > 0
end
if ( @Level = 4)
begin
select top 1 @Path = convert(varchar(100),A.IDMember)+ '-'+convert(varchar(100),B.IDMember)+'-'+convert(varchar(100),C.IDMember)+'-'+convert(varchar(100),D.IDMember)
from wtcomValidRelationships as A, wtcomValidRelationships as B, wtcomValidRelationships as C, wtcomValidRelationships as D
where A.IDMember = @IDMember and charindex(convert(varchar(100),B.IDMember),A.RelationshipIDS) > 0
and charindex(convert(varchar(100),C.IDMember),B.RelationshipIDs) > 0 and charindex(convert(varchar(100),D.IDMember), C.RelationshipIDs) > 0
and PATINDEX('%'+@IDOther+'%',D.RelationshipIDs) > 0
end
if (@Level = 5)
begin
select top 1 @Path = convert(varchar(100),A.IDMember)+ '-'+convert(varchar(100),B.IDMember)+'-'+convert(varchar(100),C.IDMember)+'-'+convert(varchar(100),D.IDMember)+'-'+convert(varchar(100),E.IDMember)
from wtcomValidRelationships as A, wtcomValidRelationships as B, wtcomValidRelationships as C, wtcomValidRelationships as D, wtcomValidRelationships as E
where A.IDMember = @IDMember and charindex(convert(varchar(100),B.IDMember),A.RelationshipIDS) > 0
and charindex(convert(varchar(100),C.IDMember),B.RelationshipIDs) > 0 and charindex(convert(varchar(100),D.IDMember), C.RelationshipIDs) > 0
and charindex(convert(varchar(100),E.IDMember),D.RelationshipIDs) > 0 and PATINDEX('%'+@IDOther+'%',E.RelationshipIDs) > 0
end
if (@Level = 6)
begin
select top 1 @Path = '' from wtcomValidRelationships
end
END

View Replies !

How To Save A Stored Procedure With Management Studio?
Hi,
i can make and save a stored procedure in Visual Web Developer (via Database Explorer). It appears then in the list op stored procedure in Management Sudio.
But how to do the same in Management Studio? When i make a sp and i want to save it, Management Studio asks me a name, but put the file in a Projects directory in 'My documents'. It never appears in the list of sp.
Thanks
tartuffe

View Replies !

Stored Procedure Executing Durations Are Different Between Executing From Application(web) And SQl Server Management Studio - Qu

Hi,

I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query window

Please see the image through this url http://kyxao.net/127/ExecutionProblem.png

Any ideas for this issue?

Thanks a lot

View Replies !

Stored Procedure Executing Durations Are Different Between Executing From Application(web) And SQl Server Management Studio - Query Window
Hi,I have a web application using Stored Procedure (SP). I see that there's a SP taking long time to execute. I try to capture it by Profiler Tool, and find out that with the same SP on the same db with the same parameter. The duration of executing by my web app is far bigger than the duration of executing on SQl server management studio - query windowPlease see the image attached http://kyxao.net/127/ExecutionProblem.png Any ideas for this issue?Thanks a lot Jalijack

View Replies !

How To Test Stored Procedure With Output Parameters In Management Studio
I have this SP:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[GetSessionInformation]
@CustomerID int,
@Success bit OUTPUT,
@Email VarChar(55) OUTPUT,
@FirstName VarChar(55) OUTPUT,
@LastName VarChar(50) OUTPUT,
@PhoneNumber VarChar(50) OUTPUT,
@CompanyName VarChar(50) OUTPUT
AS

SET NOCOUNT ON

DECLARE @UserKey AS int

SELECT @CustomerID = CustomerID
FROM Customers
WHERE CustomerID = @CustomerID

IF @CustomerID IS NULL
BEGIN
SET @Success = 0
END
ELSE
BEGIN
SET @Success = 1
END

BEGIN

SELECT customerID, Email, FirstName, LastName, PhoneNumber, CompanyName
FROM Customers
WHERE CustomerID = @UserKey

How do I test it in management studio?

When I run a EXECUTE GetSessionInformation 56

I get this error:
Procedure 'GetSessionInformation' expects parameter '@Success', which was not supplied.

Thanks for any help!

View Replies !

T-SQL And Visual Basic 2005 Codes That Execute A User-Defined Stored Procedure In Management Studio Express (Part 2)
Hi Jonathan Kehayias, Thanks for your valuable response.

I had a hard time to sumbit my reply in that original thread yesterday. So I created this new thread.

Here is my response to the last code/instruction you gave me:

I corrected a small mistake (on Integrated Security-SSPI and  executed the last code you gave me.

I got the following debug error message:

1) A Box appeared and said:   String or binary data would be truncated.

                                             The statement has been terminated.

                                                            |OK|

2) After I clicked on the |OK| button, the following message appeared:

                                   This "SqlException was unhandled

                                             String or binary data would be truncated.

                                             The statement has been terminated."

                                    is pointing to the "Throw" code statement in the middle of

                                                                                 .......................................

                                                                                 Catch ex As Exception

                                                                                       MessageBox.Show(ex.Message)

                                                                                       Throw

                                                                                  Finally

                                                                                  ..........

Please help and advise how to correct this problem in my project that is executed in my VB 2005 Express-SQL Server Management Studio Express PC.

Thanks,
Scott Chang

The code of my Form1.vb is listed below:

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Public Class Form1

Public Sub InsertNewFriend()

Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;"

Dim connection As SqlConnection = New SqlConnection(connectionString)

Try

connection.Open()

Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)

command.CommandType = CommandType.StoredProcedure

command.Parameters.Add("@procPersonID", SqlDbType.Int).Value = 7

command.Parameters.Add("@procFirstName", SqlDbType.NVarChar).Value = "Craig"

command.Parameters.Add("@procLastName", SqlDbType.NVarChar).Value = "Utley"

command.Parameters.Add("@procAddress", SqlDbType.NVarChar).Value = "5577 Baltimore Ave"

command.Parameters.Add("@procCity", SqlDbType.NVarChar).Value = "Ellicott City"

command.Parameters.Add("@procState", SqlDbType.NVarChar).Value = "MD"

command.Parameters.Add("@procZipCode", SqlDbType.NVarChar).Value = "21045"

command.Parameters.Add("@procEmail", SqlDbType.NVarChar).Value = "CraigUtley@yahoo.com"

Dim resulting As String = command.ExecuteNonQuery

MessageBox.Show("Row inserted: " + resulting)

Catch ex As Exception

MessageBox.Show(ex.Message)

Throw

Finally

connection.Close()

End Try

End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

InsertNewFriend()

End Sub

End Class

View Replies !

T-SQL And Visual Basic 2005 Codes That Execute A User-Defined Stored Procedure In Management Studio:How To Declare EXEC && Sp?
Hi all,

In my SQL Server Management Studio Express (SSMSE), I executed the following sql code suuccessfully:
--insertNewRocord.sql--

USE shcDB

GO

CREATE PROC sp_insertNewRecord @procPersonID int,

                                                       @procFirstName nvarchar(20),

                                                       @procLastName nvarchar(20),

                                                       @procAddress nvarchar(50),

                                                       @procCity nvarchar(20),

                                                       @procState nvarchar(20),

                                                       @procZipCode nvarchar(20),

                                                       @procEmail nvarchar(50)

AS INSERT INTO MyFriends

VALUES (@procPersonID, @procFirstName, @procLastName, @procAddress,

@procCity, @procState, @procZipCode, @procEmail)

GO

EXEC sp_insertNewRecord 7, 'Peter', 'Wang', '678 Old St', 'Detroit',

'Michigon', '67899', 'PeterWang@yahoo.com'

GO

=======================================================================
Now, I want to insert a new record into the dbo.Friends table of my shcDB by executing the following T-SQL and Visual Basic 2005 codes that are programmed in a VB2005 Express project "CallshcDBspWithAdoNet":
--Form1.vb--

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Public Class Form1

Public Sub InsertNewFriend()

Dim connectionString As String = "Integrated Security-SSPI;Persist Security Info=False;" + _

"Initial Catalog=shcDB;Data Source=.SQLEXPRESS"

Dim connection As SqlConnection = New SqlConnection(connectionString)

connection.Open()

Try

Dim command As SqlCommand = New SqlCommand("sp_InsertNewRecord", connection)

command.CommandType = CommandType.StoredProcedure

EXEC sp_insertNewRecord 6, 'Craig', 'Utley', '5577 Baltimore Ave',

'Ellicott City', 'MD', '21045', 'CraigUtley@yahoo.com'

Console.WriteLine("Row inserted: " + _

command.ExecuteNonQuery().ToString)

Catch ex As Exception

Console.WriteLine(ex.Message)

Throw

Finally

connection.Close()

End Try

End Sub

End Class

===========================================================
I ran the above project in VB 2005 Express and I got the following 5 errors:
1. Name 'EXEC' is not declared (in Line 16 of Form1.vb)
2. Method arguments must be enclosed in parentheses (in Line 16 of Form1.vb)
3. Name 'sd-insertNewRecord' is not declared. (in Line 16 of Form1.vb)
4.Comma, ')', or a valid expression continuation expected (in Line 16 of Form1.vb)
5. Expression expected (in Line 16 of Form1.vb)
============================================================
I know that "EXEC sp_insertNewRecord 6, 'Craig', 'Utley', '5577 Baltimore Ave',

'Ellicott City', 'MD', '21045', 'CraigUtley@yahoo.com' "in Line 16 of Form1.vb is grossly in error.
But I am new in doing the programming of T-SQL in VB 2005 Express and I am not able to change it.

Please help and advise me how to correct these problems.

Thanks in advance,
Scott Chang

View Replies !

Stored Procedures Not Showing In Server Management Studio
i'm trying to create my first stored procedure.
i believe i've done everything correctly, the file shows up in the projects directory with the .sql extension, but the proc doesnt appear in object explorer under my database name/programmability/stored procedures.
when i execute the query, i get "Could not find stored procedure 'IsEmployeeInTable'.".
i'm running on my laptop using asp.net development server.
thanks. matt

View Replies !

MS SQL Server Management Studio - Permissions And Stored Procedures
Hi

My website uses GET variables a lot and i'm trying to safe guard as much as possible against SQL injection attacks. I'm trying to create permissions which will deny a user to Delete/Insert/Update various tables.

I have managed this with the tables themselves, but when using a stored procedure, the tables do not take into account the user permissions which were set for that table!

Basically, how do i stop a stored procedure from Deleting/Inserting/Updating tables? :(

many thanks

View Replies !

Viewing Large Numbers Of Stored Procs In SQL Server Management Studio
I work with a large and complex reporting system with several hundred reports: the Programmability; Stored Procedures node of the object explorer has become very difficult to navigate.

Is there any metadata that can be embedded in the stored procs that would create subfolders like the existing System Stored Procedures node in this node of the object explorer?

I suspect that the correct answers are:

Rename all your queries with a rational naming convention;
Cull the deadwood;
Assign them to categories then export them to separate databases.

Unfortunately, one of these has already been done, and the other two will break several hundred dependent processes - the recoding and retesting is neither economical nor desirable.

Still, all advice is welcome. Pitch your answers at a banking geek who does intermediate to advanced stored procedures and triggers, but isn't allowed to play with sharp things (like sys objects) - but I can probably get help from a grown-up on the sysadmin team: I have discovered that the rumours about human sacrifice are baseless, and they will perform favours in return for beer.

This is also a good time to ask: just how many stored procs and functions are you allowed in SQL Server 2005?

Nile.

View Replies !

Visual Studio Database File And SQL Server Management Studio Express Question
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason

View Replies !

SQL Server Management Express Studio Management Tools

I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.

View Replies !

Visual Studio 2005 Standard And SQL Server Management Studio?
I am new to visual studio and I am still not sure of all its components and features.

I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?

I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?

I want to add pictures of products to my shopping site using an SQL database and Iâ€™ve been told that SQL Server Management studio is required as it is a graphical tool.

How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.

Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include â€˜dynamically generatedâ€™ product images if that is the correct terminology.

My goodness, it seems I still have so much to learn.

Thanks

View Replies !

How Do I Get The Database That I Am Using In Visual Studio Into My SQL Server Management Studio?
How do i get the database that i am using in visual studio into my SQL server management studio?
i need to create some scripts to create stored procedures on a live server.

View Replies !

Different Results When Running Procedure From Management Studio Vs Application Code
I'm updating a process that recreates a large table every night. The table is the result of a bunch of nightly batch processes and holds a couple million records. In the past, each night at the end of the batch jobs the table would be dropped and re-created with the new data. This process was embodied in dynamic sql statements from an MFC C++ program, and my task is to move it to a SQL Server 2000 stored procedure that will be called from a .Net app. Here's the relevant code from my procedure:
sql Code:

Original
- sql Code

-- recreate new empty BatchTable table
print 'Dropping old BatchTable table...'
exec DropBatchTable --stored procedure called from old code that does a little extra work when dropping the table

-- validate drop
If exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BatchTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin
RAISERROR( 'Unable to drop old BatchTable!',0,1) WITH NOWAIT
End Else Begin
print 'Old BatchTable dropped.'
End

print 'Creating new BatchTable...'
SELECT TOP 0 *, cast('' as char(3)) as Client, cast('' as char(12)) as ClientDB
INTO dbo.BatchTable
FROM differentDB.dbo.BatchArchives

--validate create
If Not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BatchTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin
RAISERROR( 'Unable to create new BatchTable!',0,1) WITH NOWAIT
End Else Begin
print 'New BatchTable Created.'
End

-- recreate new empty BatchTable table print 'Dropping old BatchTable table...' exec DropBatchTable --stored procedure called from old code that does a little extra work when dropping the table -- validate drop IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[BatchTable]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN RAISERROR( 'Unable to drop old BatchTable!',0,1) WITH NOWAIT END ELSE BEGIN print 'Old BatchTable dropped.' END print 'Creating new BatchTable...' SELECT TOP 0 *, CAST('' AS CHAR(3)) AS Client, CAST('' AS CHAR(12)) AS ClientDB INTO dbo.BatchTable FROM differentDB.dbo.BatchArchives --validate create IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[BatchTable]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN RAISERROR( 'Unable to create new BatchTable!',0,1) WITH NOWAIT END ELSE BEGIN print 'New BatchTable Created.' END

The print statements are there because the .net app will read them in and then write them to a log file. Some of the other mechanics are there to mimic the old process. The idea is to duplicate the old process first and then work on other improvements.

This works in Management studio. The .Net App reports that the old table was dropped, but when it tries to create the new table it complains that "There is already an object named 'BatchTable' in the database." I have verified that the old table is removed.

Any ideas on how to fix this?

View Replies !

Bug In Management Studio : Cannot Add Procedure Article For Heterogeneous Transactional Replication
Hi,
I'm setting up a heterogeneous transactional push replication with Sybase ASE 12.5.3 as subscriber. With management studio I try to create an procedure article with following properties

Copy extended properties       : false
Destination object name     : pGS_RefuseRequest
Destination object ownere       : dbo
Action if name is in use          : keep existing object unchanged
Replicate                           : Execution of the stored procedure
Create schemas at Subscriber : false

When I save the article and then the publication I got following error message:

Can not add artice 'pGS_RefuseRequest'.
Object was not found on server. Check if this object exists on the server. (Microsoft.SqlServer.Rmo)

That's realy strange because the wizard offered the procedure pGS_RefuseRequest in the list of possible articles.

Fortunatly I can create the article with following TSQL statement :

exec sp_addarticle @publication = N'RIGHTS_EDV_4T_pub'
, @article = N'pGS_RefuseRequest'
, @source_owner = N'dbo'
, @source_object = N'pGS_RefuseRequest'
, @type = N'proc exec'
, @description = N''
, @creation_script = N''
, @pre_creation_cmd = N'none'
, @schema_option = 0x00
, @destination_table = N'pGS_RefuseRequest'
, @destination_owner = N'dbo'
, @status = 0
go

Did anybody seen this bug before ?
It seems to be specific for heterogeneuous replication. In a pure MS environement the Wizard works fine!

Wolfgang Kunk

View Replies !

SQL Server 2005 Managment Studio Newbie: Can't See Stored Procedure
I just created a stored procedure in SQL Server 2005 management studio. I went to my db and expanded the programmability folder then right clicked the stored procedures folder and created a stored procedure. I saved the procedure as sp_getDistance in the default folder SQL managment studio picked. Now when I went back to that stored procedure folder I did not see my stored procedure sp_getDistance, all that was there was the system stored procedure folder. Did I save the stored procedure in the wrong place, or what did I do wrong. I can't find the procedure anywhere, its just sitting in my My DocumentsSQL Server Management StudioProjectssp_getDistance.sql folder. Thanks,Kyle Spitzer

View Replies !

Testing A Stored Procedure With Output Params In SQL Server Managment Studio
I have an SP like this (edited for brevity):

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[TESTING_SP]
@Username MediumText,
@Password MediumText,
@UserKey int OUTPUT,
@RoleKey int OUTPUT,
@UserGroupKey int OUTPUT,

AS

BEGIN

SELECT
@UserKey = UserKey
FROM UserProfile
WHERE Username = @UserName
AND [Password] = @Password
END

I want to execute this sp in Managment Studio (MS) and see what is being returned but I'm getting this error:

Msg 201, Level 16, State 4, Procedure TESTING_SP, Line 0
Procedure 'TESTING_SP' expects parameter '@UserKey', which was not supplied.

How do I set up the output parameters and then select the values in MS for testing purposes?

Thanks a ton for helping a noob.

View Replies !

What Is The Security Setting To Allow Editing Of Stored Procedures From Management Studio?
Greetings
Running SQL Server 2005. The developers on the project can see and edit stored procedures from within the Visual Studio IDE (via Server Explorer) but when they connect through management studio, the stored procedures do not show up at all.

Is there a seperate security setting specifically for management studio?

The user has:

The dbCreator Server Role

Is mapped to the development database as dbo with datareader/datawriter/db owner/public role
Is mapped to master reader/writer/public
Is mapped to model reader/writer public
Is mapped to msdb reader/writer public
Is mapped to tempdb reader/writer publuc

This is probably more security than the user needs, but was grasping at straws to let them edit stored procedures...

View Replies !

User 'Unknown User' Could Not Execute Stored Procedure - Debugging Stored Procedure Using Visual Studio .net
Hi all,

I am trying to debug stored procedure using visual studio. I right click on connection and checked 'Allow SQL/CLR debugging' .. the store procedure is not local and is on sql server.

Whenever I tried to right click stored procedure and select step into store procedure> i get following error

"User 'Unknown user' could not execute stored procedure 'master.dbo.sp_enable_sql_debug' on SQL server XXXXX. Click Help for more information"

I am not sure what needs to be done on sql server side

We tried to search for sp_enable_sql_debug but I could not find this stored procedure under master.

Some web page I came accross says that "I must have an administratorial rights to debug" but I am not sure what does that mean?

Please advise..

Thank You

View Replies !

Server Express, Management Studio Express, Visual Studio Standard, And An ASP.NET Page....
I believe I'm missing something as far as my configuration goes...I'm new to working with SQL server and the databinding I'm trying to do.

I have an ASP.NET page that has a radio button list box which I have databound to a database served up by SQL Express

I'm having a lot of problems with connections...

I was going to enumerate the behavior under each configuration (local only, remote tcp/ip only, remote pipes only, remote both), but I've realized that it is just flaky. Sometimes I can connect to the db with SQL Studio express, sometimes not. Sometimes I can add new tables and edit tables, sometimes not. Sometimes I can create a new connection when trying to databind from within Visual Studio, and sometimes not (sometimes I can't even connect, other times, I can connect initially but when I build a query through the designer it then has problems). Lastly, sometimes the ASP.NET page works correctly and sometimes not.

This all seems to be mostly independent of how I configure SQL Server as far as what kinds of connections are allowed. I thought there was a pattern, but as I tested it more rigorously I found there wasn't.

What I would like to do is be connected to the same DB with Visual Studio and SQL Studio, edit the DB as I wish, databind to it, and test my ASP.NET page, all without needing to jump through a bunch of hoops (although right now I wouldn't even know what those hoops are...it's just a shot in the dark as to what will work).

It's all quite maddening and any help would be appreciated.

View Replies !

Need Help With Stored Procedure Management
Hi again,
Background: I have a stored procedure that I use to pull records to be diplayed in a gridview. There is a requirement that the users should be able to search using some criteria (supplied from textboxes) and also opt to search exact match (without LIKE clause) or wildcard match (with LIKE clause). To accomplish this, I created an identical copy of the existing stored procedure and removed all LIKE clauses. I then just check if the user wanted an EXACT or LIKE match and then call the appropriate procedure. Now there is another requirement to filter out records that have toll free numbers in them (based on user choice. NOTE: Toll Free Numbers = numbers starting with 800,866,877,888).
Problem: Should I create additional stored procedures to accomplish this? If I go this way, then I am worried if more requirements like this arise, tt will be very difficult to manage so many stored procedures. Or, should I use if() statements in stored procedures which get executed according to the flag parameters sent from the code? I have read that if I have if() blocks in stored procedures, they are recompiled every time they are accessed possibly affecting performance.
Any suggestions.
Thanks

View Replies !

About SQL Server Management Studio Help!!!
i have SQL Server 2005 dev edition and i wanted to use SQL Server Management Studio so is it installed or i need to install the SQL Server Management Studio express edition ???
thx

View Replies !

SQL Server Management Studio
Hey everyone,
Would someone please tell me why the new SQL Server Managment Studio comes with hardly not frills? What happened to the SQL Enterprise Manager in SQL Server 2000? It had DTS, SQL Agent Job and step viewing, Cool Wizards.. All that great stuff. but with this new Sql Server Management Studio with 2005 all I can do is pretty much look at the data and write queries and create and modify tables. Am I missing something?
I did download an external tool which was called an import/export wizard but it sucks compaired to the DTS in SQL 2000.
I did notice when I open my Sql Server Management Studio "Express" that it is the Express version... Is there a difference?
Thanks for any help.

View Replies !

SQL Server Management Studio
I have SQL server 2005 developer edition installed on my machine. I was expecting something like Enterprise manager to manage databases but nothing is installed by default. Ive found SQL server management studio express and installed it, but Ive also seen references to SQL Server Management Studio. Are there any differences between the two , or are they the same and are just described differently ?? Im a bit confused, Microsoft should make this clear.

View Replies !

SQL Server Management Studio
I have installed SQL Server Management Studio (for SQL2005) to a pc. When the user boots the pc, the following error is received:

fmaagent.exe - Common Language Runtime Debugging Services
Application has generated an exception that could not be handled.
Process id =0x328 (808), Thread id=0x32c (812).

Click Ok to terminate the application.
Click CANCEL to debug the application.

After clicking on OK, the pc continues on its merry way and boots up successfully.

Does anyone know what would cause this error? I have checked the Microsoft site but did not find this error listed among the documents.

The PC is running Windows XP.

Thanks in advance.

View Replies !

Sql Server Management Studio
In 2005 Query Analyzer no longer exists and the query is integrated with management studio. I have some users that want to query the database but I don' t want these users to have the ability to use anything else in the Management Studio - restore databases, detach, etc. Anyone have any ideas how this might be done? Thanks.

View Replies !

I Need SQL Server Management Studio!
Hi,

I have just completely installed MS SQL Server 2005 Express Edition in MS Server 2003.
After installation, I only have the Configuration Manager, Error and Usage Reporting and Surface Area Configuration, listed under Configuration Details.

SQL Server Management Studio is not accessible anywhere.
I also do not have the folder C:Program FilesMicrosoft SQL Server90ToolsBinnVSShell in which the SQL Server Management Studio is installed.
What must I do to get this component installed?

In this article http://msdn2.microsoft.com/en-us/library/ms143219.aspx, it is also written in step 8 that there should be a "Components to Install" page. I have done the installations and uninstallations a few times, but I still do not have "Components to Install" page. In fact, after step 7, I am brought to the "Features Selection" page.

What can I do to solve this problem? Please help.

Thanks.

View Replies !

SQL Server Management Studio
During SQL 2005 Standard edition the Management Studio did not install. how can I get it to install?

View Replies !

SQL Server Management Studio
I've install SQL Server 2005 Enterprise Evaluation Edition but the Management Studio was not installed. Is this normal? If yes how can I get the Management Studio

Thks

View Replies !

Where Is SQL Server Management Studio
I just had to do a total restore on one of my machines that has a copy of SQL Server 2005. Luckily, this is not the production server. But when I reinstalled SQL Server, I now do not have the option to get into SQL Server Management Studio. Why would this be?

Everything seemed to install okay - including Reporting Services.

Thanks for the information.

View Replies !

Where Is SQL Server Management Studio?
I have the "Ready to Launch" package, which includes Vidual Studio 2005 Standard Edition, SQL Server 2005 Standard Edition and something else called BizTalk Server 2006.

Anyway, Visual Studio is spread across two CD's and I have installed that. I now want to use the SQL Server Management Studio to administer a database I have running on a website. Anyway, SQL Server is on a DVD and when I put it into the drive it comes up with the autorun screen. I noticed that in the top left corner of this screen it says "SQL Server 2005 (Disc 1 of 2). However, there is no second disc, so I'm wondering if this is a problem or just a typo left over from the CD version.

There is two options in the menu under Install, "Server Components, tools, Books Online, and samples" and "Run the SQL Native Client Installation Wizard." I have tried both of these options and I still don't have the SQL Server Management Studio. In fact if I select the first option, when I get half way through the wizard, it asks what components I want installed. I cannot see any reference to the SQL Server Management Studio in this list, so I just select everything to be sure.

Once it has finsihed installing, all it does is create a Start Menu folder called "Microsoft SQL Server 2005" and another folder inside that called "Configuration Tools." This folder just contains a few things like configuration manager and surface area configuration, etc...

So where do I find this SQL Server Management Studio? Have I done something wrong or am I missing something (like a second disc)? I'm installing on to Windows XP, would that cause the problem? Do I need to be installing on to some sort of server OS (which I don't have BTW as I'm just a regular user looking for a way to administer my MS SQL database and I heard this tool was the way to go)?

View Replies !

SQL Server Management Studio
When attempting to start the SQL Server 2005 Management Studio from the Start Menu on my Windows 2003 SP1 server, I quickly get the error, "The Application failed to initialize properly (0x80000003). click on OK to erminate the application. I am accessing the server from my Windows XP Workstion using Timbuktu Pro Remote control software. I have no problem attaching to the SQL Server database on this server when connecting to it from my Workstation install of Management Studio. The SQL Server Business Intelligence Studio launches fine in the Timbuktu session as does SQL Server Configuration Manager. The Configuration manager shows all services (for both my Default and Named Instance) in the Running state.

Please help.

Rob

View Replies !

Using SQL Server Management Studio
Hi everyone,

I am trying to connect to my reporting server, but in Management Studio

my server type only shows 'Database Engine'. I have SQL Server Reporting Services running and I can connect to the report manager.

I would like to define a new role in Management Studio, how can I do this?

Also, in my report manager site, I do have the link to add roles.

View Replies !

Where Do I Buy SQL Server Management Studio?
I have the Express version but now need the full tool set. I've been looking for the last half hour on Microsoft.com and elsewhere, and can find absolutely anything I could want to know about the program except how to purchase it. I feel kind of stupid, but I have to ask: where the hell do you buy this thing?? :-)

Thanks.

Jeff

View Replies !

SQL Server Management Studio
This is probably a noob question, but is it possible to install SQL Server Management Studio on a remote machine (i.e. my laptop)?

View Replies !

SQL Server Management Studio
Can I set a passport protection to a database (once I am connected to the SQL Server on my own machine) from not opening/browsing/stop even read access?

(I want something like log in authentication before I open/browse/double click on any database to expand basically)

Thanks for help
J.

View Replies !

SQL Server Management Studio
David writes "I am kind of new to SQL Server Management Studio.
How do I export tables and stored procedures from a database on my PC to a database by the same name located on a remote server."

View Replies !

Where Is SQL Server Management Studio?
I installed SQL 2005 in a few server but none of them have SQL Server Management Studio.
Where to find out them?
I checked c:...inn, there is now VSShell folder.

View Replies !

SQL Server Management Studio
Good Afternoon! I installed SQL Server Express 2005 but the GUI is not visible. Someone can tell me how to install it or where I can find the executable.

Thanks.

View Replies !

Management Studion Express Alongside Full-blown Management Studio?
Is it possible to run both Sql Server Management Studio: Express and full blown side by side?

I am developing with the full blown product but would like to test Management Studio Express on the same box.
Is this possible?

Thanks

Eric

View Replies !

Stored Procedure Management Software
Can anyone recommend some software for the management of stored procedures?

These are some of the features I would like:

- Call the source code of the proc up in an "intelligent" SQL editor (code coding, auto indent, etc.)
- "Compile" the proc (run the SQL script that defines the proc), allowing for compilation to multiple databases
- Execute the proc, prompting for parameters if necessary
- Display results of proc execution in grid-like view with ability to export results to various formats
- Maintain versions of the proc source
- Automatically include code to drop the procedure before compiling
- Automatically include GRANT statements for setting the permissions of the proc, based on the way permissions are defined in the database

Any ideas?

Mickey Langley
American Cancer Society

View Replies !

Microsoft SQL Server Management Studio
I was looking for Microsoft SQL Server Management Studio but downladed Microsoft SQL Server Management Studio EXPRESS.
the express version doesn't have the SQL server agent. I read that the express doesnt support SQL server agent. Is there any add-on or service pack available for this.
I am trying to find "SQL server Management studio". Any idea where I can download it?

View Replies !

Microsoft SQL Server Management Studio
i try to open database table using Microsoft SQL Server Management Studio i got the follwing error msg i don't know what the problem

===================================
Object reference not set to an instance of an object. (SQLEditors)
------------------------------Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner() at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

View Replies !

Rename A Stored Procedure In Server Management Studio

How do you rename a stored procedure in SQL Server Management Studio? I tried right clicking on the stored procedure and I don't see a Rename option.