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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: aspijker
  • Content: Threads
  • Order by date
  1. 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!
  2. 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...
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. aspijker

    sharepoint truncates sysjobhistory (MSDB)

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

    excel graphical report

    Hi! I would like to make an excel graphical report with dts to excel. I know how to export the data to excel, but now I need an graphical report of this data. Does anyone know how to do this? Regards!
  11. aspijker

    replication

    Hi SQL server people, I want to replicate data from one sql server 2000 to another sql server 2000. I have on each server an identical database. Now in the publisher database there are a lot of INSERTS, which need to be replicated to the subscriber database on the second server. But once a...
  12. aspijker

    persists upload

    Dear programmers, I am using persists upload component. On my page I have a form with different input text fields and 1 upload (file) field. Now the uploading goed fine, only when I want to save the upload.form fields to the database it seems they are all empty: Microsoft JET Database Engine...
  13. aspijker

    sql profiler: log user logins

    Dear colleques, I need to report about how many users login, for how long (average), maximum time and minimum of period logged on, from which application and how many failed logon attempts. Can you help me make a trace template for sql profiler? Thanks! Salsa
  14. aspijker

    replicate local sql advantage db's to central ASE db

    Dear DBAérs, I am not very experienced in my DBA work for Sybase database3s. Anyway I have problems replicating several local sql advantage databases to the central ASE database. SQL advantage is the database a client uses during the day to work with, but all changes should be replicated to the...
  15. aspijker

    javascript syntax error

    Hello, I am an ASP programmer and I write javascript to the browser (with server side ASP). This page should show google maps, but doesn't even show the map. Can somebody tell me where the mistake is, i'm sure it's a syntax error! Thanks a lot! Aspijker <html...
  16. aspijker

    service (status: automatic) does NOT start op when rebooting

    Hello, I have added a service and gave the status automatic, but now it is not starting when I reboot the server. Any idea how to fix this? Regards, Aspijker
  17. aspijker

    Server Application Unavailable

    Hi people, I have installed a asp.net application. Now when trying to open the application through the browser give me an error: Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in...
  18. aspijker

    usage device from data and log to only data

    Hi, I wanted to increase a data device for my database on UNIX. Now it has increased space by 3 gb, but I see the usage is data and log, which should be only data. How can I correct this? (I use Embarcadero (dbartisan) as a tool) thanx anyone...
  19. aspijker

    javascript code to browser

    Hi! I am reading geocodes from a database to show an icon on a google map. Now the center point is displying, but the rest of the code is dispayed as text in the browser, so I actually see the javascript code in my browser. How can I send javascript to the browser, and that the browser...
  20. aspijker

    REDO files messed up, need help

    Dear DBA-people, We're working with oracle 9.2 and because of the below message I wanted to get bigger redo files. Thu Feb 01 10:48:08 2007 Thread 1 advanced to log sequence 155 Current log# 1 seq# 155 mem# 0: D:\ORACLE\ORADATA\OCTOVH\REDO01.LOG Fri Feb 02 17:06:45 2007 Thread 1 advanced to...

Part and Inventory Search

Back
Top