Triggers Info

Feb 28, 2000

Hello!
I'm new DBA.
I have triggers on my table in the database have been created one individual a long time ago. Sp_helptrigger stored procedure gave me just a little info about triggers. I would like to see the real code for each trigger, but I don't have idea where to look for it.
Please help me to find it.

Thank you
Anny.

View 2 Replies


ADVERTISEMENT

Backup Of Database - Don't Lose Info - Triggers?

Feb 13, 2007

I have a database that has a table with tons of data in it and it is getting close to the 999 days before it starts deleting the oldest records. Is there a way to allow the table to keep all of the information? I don't think there is, so here is my next question. Is there a way that I can move the entire table into another database to save all the information and start over with the 999 days? My main goal here is to not lose ANY information from any table from the database.

Also, I was thinking that when an entry is added into the main table, if it can also be added into the other table where I move the old data? I think a trigger can be used here, but I'm not sure how to do one in 2005. Thank you very much in advance for your help!!!

View 1 Replies View Related

Using Triggers To Get Recently Updated Info In SQL Server 2000

Sep 30, 2004

Hello all,

I am trying to change values of two tables in my sql server 2000 database. When one of the tables is modified in some way like adding/updating a record, I need a trigger procedure to copy this new data from the first table to the second. Problem is, how do I get the newly inserted or updated data from the first table? How do I specify that I only want the data which caused the trigger to execute? Anyone know?

Thanks,
Bob

View 1 Replies View Related

Is There A System Table With Timestamp Info Or DTS Job Info?

May 7, 2007

I want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn't work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.

ddave

View 3 Replies View Related

Multiple Triggers On A Table Or Encapsulated Triggers

May 12, 2008

This isn€™t an problem as such, it€™s more of a debate.

If a table needs a number of update triggers which do differing tasks, should these triggers be separated out or encapsulated into one all encompassing trigger. Speaking in terms of performance, it doesn€™t make much of an improvement doing either depending upon the tasks performed. I was wondering in terms of maintenance and best practice etc. My view is that if the triggers do totally differing tasks they should be a trigger each on their own.

www.handleysonline.com

View 12 Replies View Related

Last Used DB Info

Apr 4, 2006

Hi all,

I've inherited the administration of two SQL Servers one 7.0 and the other 2000. We are looking into upgrading to 2005 so I'm gathering all the info I can on the DBs and applications using them.

Now, how can I check if a DB is currently in use? Is there a way to find out when a DB was last accessed?

By the way, I've never done DB administration so you can figure out how desperate I'm getting.

Thanks all for your help,

GS

View 1 Replies View Related

Info

Jan 18, 2007

pratap writes " Dear respected sir,

i need small information regarding how the picture image data can be stored in the database and how it can be made possible. is there for the need for any conversion.

thank you

awaiting for your reply"

View 2 Replies View Related

Between And More Info

Dec 18, 2007

Hi, I hope someone can help me with this.

I want to get a query from a database

from between '3' AND '5' (NO PROBLEM)

but I want to add that I want info from 7 and up

how would I write that ? (if I do it in seperate lines the query returns nothing) which is not true.

Thank you.

View 1 Replies View Related

Help With Db Info.

Oct 1, 2007

Well i need to document what tables i have in my stored procedures. Im really new to sql as well. And the problem is if i try code i have or sp_depends for instance it will only tell me the tables that are in that DB so if I have multiple tables from different DB's they are left out. I was told that sp_MSForEachDb for go through each DB and I could try it that way. Any help or example code dumbed down for me would be awesome. This was posted in a previous thread but i though this would be a better explanation

View 3 Replies View Related

Need Info From 2 Tables

Sep 18, 2007

Here's my string.  I know it's way wrong right now  SELECT binbox_receipt.partner_code    ,binbox_receipt.link_id ,binbox_receipt_archive.partner_code,binbox_receipt_archive.link_id     FROM binbox_receipt, binbox_receipt_archivewhere binbox_receipt_archive.link_id = binbox_receipt.link_idand binbox_receipt.partner_code = '1154' and binbox_receipt.link_id = '2684'and (binbox_receipt_archive.partner_code  = '1154' and binbox_receipt_archive.link_id  = '2684')I need to check 2 tables if in the first table the link_id and partner_code exist or the second table link_id and partner_code existany help would be greatly appreciated I'm a little new at this but having fun trying 

View 11 Replies View Related

Info Regarding MSDE

Nov 14, 2003

Hi

Iam not sure if the Question is approriate for this forum but here goes....

I have just started playing around with ASP .NET and since i do not have a lot of money i downloaded and installed MSDE as my database. So far i havent been able to find any free tools to access MSDE. Iam looking for GUI tools from where i can create Databases , tables etc... I have experience with MySQL database and am looking for something like MySQLAdmin for MSDE..


any help in this regard is appreciated

Thanks
Punit

View 1 Replies View Related

Need Help Parsing Out Info

Jul 22, 2004

Hi All,

I'm using a SQL selection to fill a DataGrid. One of the fields I have is called diagnosis. This field in the database can contain multiple diagnosis. But I use a set of characters to divide each diagnosis.
Example : Sick!@#$%Hurt!@#$%Ill!@#$%
My problem is this is how it looks in my Data Grid. Can someone tell me how to parse out each diagnosis.

Thanks

View 1 Replies View Related

Spid Info

May 12, 2000

Hi,
Here i have a question..
Whenever i see my spid in LOCK/PROCESS ID
one command DBCC BUFFERINPUT(MY SPID) always running
and it is showing ''''tempdb.dbo.##lockinfo'''
MODE---- X
Is it pretty normal or something wrong..
i am not running any thing, just simply opened EM..
Pls any suggestions...
thank u

kavira

View 2 Replies View Related

Processor Info

Jan 23, 2003

After Sql server has been installed. Is there a way to find out for the mode that it is installed in, ie per processor or per seat?

Thanks

View 1 Replies View Related

Info On SQLPERF

Apr 4, 2001

Can anyone point me in the direction of some online resource that explains, in detail, the statistics returned by DBCC SQLPERF?

Thanks
Phill

View 1 Replies View Related

Exception_Access_Violation Info

Sep 15, 1998

To all:
I have installed a new Compaq 7000 with NT4.0 sp3 and Sql Server 6.5 sp4 into production about two weeks ago.
Everything went fine until yesterday. Around noon I received 2 Exception_Access_Violation about a second apart
with two differend spids. About 20 mins later I got the Out of connections message and sql server stopped
reponding. I Could not stop sql server and had to reboot the server. I have configured the connections at 600
and generally we average a little over 400. Everything seems to be running fine now but I would like to get some
information from all the great minds out there!

What exectly is Exception_Access_Violation? Can I figure out what caused it or can I debug it? Do you think that the
EAV caused the out of connections error? Any help, insight would help greatly!

Thanks in advanced,
Glen Whitling

View 1 Replies View Related

I Need Some Info On MS SQl Server 6.5

May 7, 1999

Respected Sir,

I am from India. My office has 15 location all over India. I am in corporate office.We have Ms Sql server 6.5. Also all other centers have
have same Ms Sql Server 6.5. We develop a Intranet based application.
In which Ms Sql Server 6.5 is the back end and Netscape browser is the front end.

The centers have their independent database. all also have different data structurre.
But the Head Office needs data from them. How the replication technology help us. and How we we will conect through internet or we haveto have seprate dedicated
leased lines back to centers.

What will be data structure .

Himansu

View 1 Replies View Related

Best Way To Log Statistical Info

Apr 12, 2007

I want to keep track of some application statistics.

-How many applications per day, month, year
-How many apps for a specific type of widget
-etc.


Is this best accomplished by a script that review the data or by using counters that are updated with every app?

Can someone give me some info on how to get started with this? I did a search, but only found a thread that recommends an article that costs $100.

View 9 Replies View Related

Process Info

Jan 11, 2005

I want to check who access the database in the sql server. When i go to current activity then process info. I found not all the users who access the database are displayed. Even though i refresh it. It didn't show up. But i am sure some user was accessing the database. Anybody know why, how can i avoid it. Thanks.

View 2 Replies View Related

Sql Server Info

Mar 3, 2005

Hi All,

What is similar to "Schema" and "Table space" in SQL Server?

What is the physical organization/structure of SQL Server?

Thanks in advance,
Jai

View 7 Replies View Related

Trace Info

Feb 19, 2004

Folks, I've inherited a SQL 2K server that has a trace running. I can see the trace file being generated(.trc), I can also see the standard templates(.tdf). But BOL is not helpful in finding information about the
trace when you have no information. I just want to shut the damn thing off.

I can open the trc file in SQL Profiler but I am not proficient in the tool's use. I also don't see a trace table anywere in the database.

If anyone can be of any help it would be much appreciated. Thanks.

View 7 Replies View Related

Not Sure How To Get Info From Other Table

Aug 31, 2005

I am having problems with my store procedure displaying my last column name which is "DISPLAY_CATEGORY_DESC". I am trying to display the description from another table. But in order to get to the description I have to go through 2 tables. The tables look like something like this.

First TableTABLE_CATEGORY

PRIMARY_KEY = DIR_CATEGORY_ID = 5000

Column Name
DIR_CATEGORY_LVL_ID1 = 100
DIR_CATEGORY_LVL_ID2 = 200
DIR_CATEGORY_LVL_ID3 = 300

Second TableTABLE_CATEGORY_DESCRIPTION
PRIMARY KEY DIR_CATEGORY_LVL_ID1 = 100

Column Name
DESCRIPTION = "Car Model Company"

This is my DISPLAY_CATEGORY_DESC

Not sure how to get to this description. Thanks for your help.


select cwebs.SESSION_ID, webs.ENTERED_DATE, cwebs.DIR_CATEGORY_ID, DISPLAY_CATEGORY_DESC

FROM di_webclickstats cwebs
left join di_websessions webs on cwebs.session_id = webs.session_id
where cwebs.DIR_CATEGORY_ID <> 0 and webs.ENTERED_DATE between @startDate and @endDate+1

View 3 Replies View Related

Some Info On MS SQL Server

Mar 1, 2006

I have developed a great intrest in the MS SQL Server recently. I was just wondering if it was worth putting my time into learning this system. In the members opinion would SQL server be technically fit? Does it have a good campacity and flexibility? These areas are quite important to me. I would also like to know how web friendly the server is and its ability to handle complex data.

Any help would be much appriciated.

View 2 Replies View Related

Newbie Need Some Info

Mar 10, 2006

Hi there,

I have been asked buy my boss to try and solve a problem. We have a access database which has a hell of a lot of entries. We want to use sql server to store this database now.

We want to be able to print reports and analyze the data by running queries etc.

Apart from the obvious sql server software, what would be required to acheive this, would i need a dedicated front end built?

Im just testing water at the moment looking for any info that i might need.

Thanks

Trev

View 5 Replies View Related

Exceptions Info

Jan 11, 2007

Vikas writes "can any one help me in getting the list of exceptions and there types and how to tackle them."

View 1 Replies View Related

Yesterday's Info

May 25, 2007

how do i get yesterdays records only?

View 20 Replies View Related

Trouble With Info

Oct 23, 2007

I dont know if this is the right place to post this lets hope. I need to get the total of sales for say marketed.

im trying a script like this but its not doing it right

IIF( Fields!Type.Value = "Non Promotional" then Fields!TotalSales.Value = 0 else Fields!TotalSales.Value)

View 9 Replies View Related

Index Info

Dec 18, 2007

how can we check the index info about the tables in enterprise manager.

View 2 Replies View Related

Database Info

Jan 15, 2008

Hi,

I need to list in Word doc all the databases, tables and sp under a server. Is there a quick method of doing that?

Thanks

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

View 3 Replies View Related

Info Dumped

Mar 4, 2008

game server dont have a Data souce, they get there info while its going, then all that info is dumped after each round is over. I just twant the info to be stored into a DB then after each ggame is over to be dumped. all the info is dynamic.

View 2 Replies View Related

Dependency Info

Jul 23, 2005

I am under the impression that either there are deficiencies in the way SQLServer 2000 is keeping track of depedencies or perhaps the dependenciessimply need to be re-evaulated / recompiled.What is the best and/or easiest way to ensure that the dependency info isaccurate?Is there a way to tell MSSQL to rebuild/reexamine them all?Thanks in advance to the MVPs and other generous and knowledgable posterswho have helped me recently.Chad

View 2 Replies View Related

SQL Profiler Info Req

Jul 20, 2005

Would anyone happen to know where I might find good tutorials, papers,examples of using SQL Profiler ? I've searched the Internet and B.O.L. hassome info but it seems a bit disjointed. I feel like this tool is quite agood source of information but can't quite get my arms around it well enoughto take advantage of all that's there.jb

View 1 Replies View Related

ActiveX Info

Jul 20, 2005

I'm getting a little confused about what is supported in MS-SQL ActiveX andwhat is Visual Basic and what is VBScript. Can someone please point me to awebsite, recommend a book or if I've missed it where in the MS-SQL help thatdeals with the ActiveX supported in SQL. I'm not looking to do web pagesASP, ect. I'm looking to use the ActiveX as add on funtionality to supportthe Stored Procs I write.Thanks,-p

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved