Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aspijker

    trigger on sysobjects

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

    trigger on sysobjects

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

    trigger on sysobjects

    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!
  4. aspijker

    re-install system stored procedures sql 2000

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

    re-install system stored procedures sql 2000

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

    agent not sending notification email when job fails

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

    agent not sending notification email when job fails

    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!
  8. aspijker

    agent not sending notification email when job fails

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

    global var in SQL

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

    global var in SQL

    I rather not use a temporary table
  11. aspijker

    global var in SQL

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

    Connecting to linked server

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

    How can i do this in T-SQL?

    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 =...
  14. aspijker

    How can i do this in T-SQL?

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

    How can i do this in T-SQL?

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

    perfmon as resource in cluster?

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

    Microsoft OLE DB Service Components error '80040e21'

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

    sharepoint truncates sysjobhistory (MSDB)

    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?
  19. aspijker

    history empty

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

Part and Inventory Search

Back
Top