Search results for query: *

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

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...

Hey, good idea! Just another thing that comes to my mind: is it easy to migrate the second instance to another server, later in the future?

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...