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 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!
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...
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
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 =...
iS THE FOLLOWING POSSIBLE IN t-sql?
basically i want to check all the field in a database if they are not null and print the message.
DECLARE @MESSAGE AS varchar (100)
SELECT
@MESSAGE
CASE FIELD1
WHEN NULL OR NOT Like '%[0-9]%' THEN @MESSAGE = 'FIELD1 is not numeric or NULL',
CASE FIELD2...
Hi,
I'm a DBA where my SQL server is running on a clustered environment. We have two nodes and recently I found out that when there is a failover the performance counters (which I'm saving in SQL server) are not saved anymore. A logcal conclusion would be that the performance monitor is not...
I'm getting the following error:
Microsoft OLE DB Service Components error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/includes/databaseverbinding.asp, line 16
I'm actually only trying to connect with the...
Dear people,
We want to implement Sharepoint, but as a DBA I have some problems. Sharepoint has several jobs running every minute. This causes the logfile to be filled with sharepoint messages about the jobs. Now there is no history of my other jobs (from production databases). This is really...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.