Recent content by Maxxamillian

Thanks a bunch for the tip!

Thanks a bunch for the tip!

Not quite sure what you mean by using an identity column. With the "from" removed from the code the trigger still will not fire.

Need to set a trigger so that when a new record is inserted the max value in column flx_objid will be taken and incrememnted by one for the new record. So far no luck. Here is what I am working with. CREATE TRIGGER FLXTrans_ObjidCount ON FLX_Transaction FOR INSERT AS DECLARE @MaxCount...

This is what I have so far.... I have tried several different codes and none will fire. CREATE TRIGGER FLXTrans_ObjidCount ON FLX_Transaction FOR INSERT AS DECLARE @NewCount INT, @MaxCount int IF (SELECT Count(*) FROM inserted WHERE flx_objid IS NULL) > 0 BEGIN SELECT @MaxCount=...

Need to create a trigger that automatically increases the value in the flx_objid column by 1 when an insert occurs. Not quite sure how I would go about doing this as this will be my first trigger. Any help would be appreciated.

SNMP.exe is locking up the processor resources (99%) in the afternoons at about 4pm. We cannot pinpoint the reason why this is so. We have tried disabling different services and (including SNMP) to no avial. Any help or information would be appreciated.

Finally did it. Here is the final code. Dont need the help anymore but thanks anyways. CREATE PROC spUpdFsrHeaderID AS --Declare parameters. Names = column headers DECLARE @StartValue int DECLARE @EndValue int DECLARE @NextValue int DECLARE @ValueWidth int DECLARE @String...

Just need to be able to print out the value in next_value column but cant get it to go! CREATE PROC spUpdFsrHeaderID AS --Declare parameters. Names = column headers DECLARE @StartValue int DECLARE @EndValue int DECLARE @NextValue int DECLARE @ValueWidth int --declare new...

I have started to create the following SPROC: CREATE PROC spUpdFsrHeaderID AS --Declare parameters. Names = column headers DECLARE @start_value int DECLARE @end_value int DECLARE @next_value int DECLARE @value_width int --set parameters to equal information already contained within...

Thank you thank you thank you! The crux of the hypothesis is the biscuit.

Should I rebuild indexes as part of my daily/weekly database managment/maintenance and if so how often? The crux of the hypothesis is the biscuit.

Need to identify all of the tables that LIKE 'adp%' which have a column titled OBJID. I will then need to go to these tables individually and drop this column. Am a beginner here (with T-SQL) so any help/tips would be greatly appreciated. Additionally, any source material that could help me...

run away is where these processes (in the task manager) are both using up the processing capabilities of the server. They pretty much split CPU usage 50-50. This can go on for hours on end (until I reboot the machine.) Unfamilliar with these two programs and why they are kicking on. The crux...

I am getting run away processes on Inetinfo.exe and Msdtc.exe and it is locking up the server. This is happening about 1X/week. Running MSSQL6.5 The crux of the hypothesis is the biscuit.