Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [stored-procedures]

36 questions
4
votes
3 answers

How safe is SQL Server's encryption of stored procedures?

Background I am using SQL Server 2008 Enterprise on Windows Server 2003 Enterprise. I developed some stored procedures for SQL Server and the machine installed with SQL Server may not be fully under my control (may be used by un-trusted 3rd…
George2
  • 1,137
  • 6
  • 22
  • 41
4
votes
1 answer

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server and in real-time have it backup to the second…
BobFranz
  • 63
  • 1
  • 3
  • 6
4
votes
1 answer

MySQL Stored Procedure Parameters are NULL

I am stumped, and was hoping someone here would have a quick and easy answer. I did a fresh install of MySQL 5.5 and am trying to pass parameters into a stored procedure. The parameter values aren't being read by the stored procedure. MySQL…
emmilely
  • 71
  • 1
  • 5
3
votes
3 answers

SQL Server: Why is recompiling stored procedures required?

I was executing the script I found on this site to mark all my tables and stored procedures for recompilation. (I changed it to also mark the stored procedures) I have a Windows Forms (.net 3.5) application which uses a lot of data tables and after…
Marc
  • 405
  • 2
  • 6
  • 12
3
votes
1 answer

DBCC Freeproccache greatly sped up sp execution time, why?

Using MSSQL 2005 Today I was called in to look at a stored procedure that started executing slowly when used from our program. Around the order of a couple seconds where it used it execute instantly. I ran SQL Server Profiler on it and it was using…
Equixor
  • 73
  • 1
  • 3
2
votes
3 answers

SQL Server store procedure encrypt is safe?

I am using SQL Server 2008 Enterprise on Windows Server 2003 Enterprise. I developed some store procedure for SQL Server and the machine installed with SQL Server may not be fully under my control (may be used by un-trusted 3rd party). I want to…
George2
  • 1,137
  • 6
  • 22
  • 41
2
votes
2 answers

Deny Stored Procedure Data Modification by User Security

I want an easy way to make a read-only user on my database. The user should have permission to execute stored procedures only if they don't modify data. I don't want to figure out which stored procedures are read-only and give permissions that way…
Mindy
  • 117
  • 2
  • 2
  • 8
2
votes
3 answers

How can I give a SQL Server user permission to run one stored procedure and nothing else?

I need to be able to remotely monitor the disk space on a SQL 2005 server. To do this I need to give a sql server user the ability to run the following stored procedure: EXEC xp_fixeddrives; Ideally this user wouldn't have permission to run other…
Dave Forgac
  • 3,486
  • 7
  • 36
  • 48
2
votes
1 answer

5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012

I am getting an error in SQL Server 2012 Database Mail when executing a stored proc to send an email from a specified address to a specified address using Office 365 as the SMTP server. The mail could not be sent to the recipients because of the…
medina
  • 135
  • 1
  • 3
  • 11
2
votes
1 answer

SQL Server 2005 question about procedure cache

Server: SQL Server 2005 SP2 64 bit, 32 gigs of memory. 2 instances of SQL server running. Main instance I'm using has 20 gigs visible. We have a situation where it appears every so often our entire procedure cache is cleared which in turn is forcing…
Equixor
  • 73
  • 1
  • 3
2
votes
2 answers

how to prevent log output from PostgreSQL stored procedure?

I am running a number of PostgreSQL scripts that used to produce excessive log output. I managed to reduce most of the output to an acceptable amount by passing --quiet as parameter to the psql command line client and adding SET…
ssc
  • 1,129
  • 3
  • 16
  • 30
2
votes
3 answers

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of tables and stored procedures. I would like the Role…
Lewray
  • 143
  • 1
  • 1
  • 6
2
votes
1 answer

MySQL Stored Procedure

I must convert some stored procedures from MS Sql Server to MySQL and in Sql Server I have these two variables: @@ERROR for a server error and @@IDENTITY for the last insert id are there MySql similar global variables?
xdevel2000
  • 191
  • 1
  • 3
1
vote
2 answers

Why can't I access stored procedures on a linked MSDE 8.x server?

I am trying to execute a stored procedure on a linked MSDE 8.x server by running the following SQL against the parent SQL Server 2000 instance... DECLARE @RC int EXECUTE @RC =…
Tim Lara
  • 187
  • 2
  • 8
1
vote
2 answers

Able to create procedures but not functions

I am able to create mysql stored procedures but not stored functions. example: DELIMITER $$; DROP FUNCTION IF EXISTS `interkm_db1`.`temp`$$ CREATE FUNCTION `interkm_db1`.`temp` () RETURNS int BEGIN return 1; END$$ DELIMITER ;$$ Error Code :…
Sydwell
  • 111
  • 4
1
2 3