Search results for query: *

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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