Recent content by aspijker

Thanks, for your replies. I won't use it on production servers ofcourse, only DBA can access those. But we have a lot of argueing about changes on sp's on the Development environment, it wuld be good to know after who made some changes.

Hi, i won't change the system table, other than adding a trigger.

Hi! I want to know who changed or added functions or stored procedures on my databases. I was thinking of creating a trigger on updates and inserts on the sysobjects table, but I can't find out how I can see which user created them. Cheers!

Hey GREAT!!! Thanx!

Hi, it is an extended stored procedure, so there is nothing to script out, sorry, forgot to mention that. Thanx for trying though :)

Hi all, While running source code in visual studio I get an error while connecting to the sql server 2000 database, that there is no permission for the user to execute sp in master: sp_sdidebug When I cjheck in the master db, I see that this sp does not exist, it does exist on other sql...

No it works fine on all my servers, accept for this server. I use the same account for all my servers. It must be something on the server.

I can't test it, because it is a sql 2000 server. I did see the messenger service was disabled, but i doubt that is used for sending notification emails. I have made a testjob which fails, but then I still don't get an email. And yes, before it worked. Regards!

Dear DBA's, On MY sql production server (2000) I am not getting the notification emails when a job failed. I restarted the agent, because usually that would solve this problem, but now it still does not work. What can I do? Regards, Salsa

Yes, I am using a temp table now, but only because there is no better way. For performance issues I rather not use them. Thank you for all your replies! Regards, Salsa

I rather not use a temporary table

Hi! I am using a lot of transactions in a sp. Within each transaction I am updating a local variable, but as soon as a transaction is committed, SQL server makes my local variable empty, so what I need is some kind of global variable. But I can't declare my own gloval variable. A transaction...

Yes you can do that: 1) add a SQL user with db_ddladmin role on the machine you want to connect to. 2) add a linked server on the sql server from where you want to connect and select the user which you use on the server to connect to the linked server (in the properties windows from the linked...

Hi Boris, Hmm, I still can't get it to work: First when it's a numeric field it complains it can't be converted. if I uncomment that part, it runs fine, only my variable @MESSAGE is empty. Regards, Salsa DECLARE @MESSAGE AS varchar (100) SET @MESSAGE = NULL SELECT @MESSAGE =...

Really thanks!! I will test it at home, but this is exactly what I need! Have a very good weekend :) Regards, Salsa