Search results for query: *

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

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.

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

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

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.

Recent test upgrade of MSSQL 6.5 to MSSQL 7. Logins carried but the accompanying passwords did not. ??? The crux of the hypothesis is the biscuit.

Want to set up replication on a MSSQL 7 db. Need to be able to sinc with field service engineers (on laptops) at least twice a day. What kind of replication would be best for this? Merge, snapshot, ect...

Receiving this error: Event ID 2019--The server was unabel to allocate from the system nonpaged pool because the pool was empty. Use the server as a MSSQL6.5 server (mainly). Memory leak?? Additionally I am running out of locks on the db--even after upping the LOCKS number. Suggestions?

I am maxing out on my locks on the 6.5 db. Each time I raise the number of locks (doubling it), the number is met within a few days. Any tips?

Need to transfer a 6.5 instance to another server for testing purposes. How do I go about doing this (specifically how do I handle the Master db?)

Will be using DTS to migrate 6.5 db to a test 7.0 server.  How (if at all) will the 6.5 db be affected?  Any tips before doing this?  

Will be using DTS to migrate 6.5 db to a test 7.0 server.  How (if at all) will the 6.5 db be affected?  Any tips before doing this?  

Will be using DTS to migrate 6.5 db to a test 7.0 server.  How (if at all) will the 6.5 db be affected?  Any tips before doing this?  

Will be using DTS to migrate 6.5 db to a test 7.0 server.  How (if at all) will the 6.5 db be affected?  Any tips before doing this?  

I am trying to clear some of my partitions (2) of SQL 7 that we use(d) for testing purposes.&nbsp;&nbsp;I keep getting this message: &quot;Unable to locate the installation log file 'C:\MSSQL7\uninst.isu' Uninstallation will not continue.&quot;<br>Is there any other way or perhaps a way to get...

Scheduled backup for one of our SQL 6.5 DB Task Scheduler not working.&nbsp;&nbsp;Logs reveal nothing.&nbsp;&nbsp;History is showing that the task did not even begin.&nbsp;&nbsp;If the server is rebooted then the scheduler will work one time and that is it. (Will perform all tasks within...