Recent content by ibethea

I have an MS Access user defined function that I must recreate in SQL Server. Public Function durCalc(projNum As String, changeDt As Date) As Integer Dim calcDur As Integer 'gchangeDt and gprojNum are global variables whose value 'come from the previous record durCalc = 0 If projNum = gprojNum...

The problem is explained after the Select statement. The problem is within the where clause, using "IN(@text)". ALTER Procedure usp_MilestoneChangeList (@chDays as int, @Text as nvarchar(100)) AS SELECT DISTINCT t_project.[JDE Proj Num], t_project.projectReportdesc...

Hi, Problem: Access 2000 .adp SQL stored procedure problem using citrix In my Access 2000 .adp application running under citrix, I am not able to successfully run any store procedures within the applcation. Where there are form objects dependent upon store procedure to populate them (i.e...

I'm not able to reference a subform to change the recordset. here is some code: ... rst.CursorLocation = adUseClient strSQL = "SELECT t_projectStaff.[JDE Proj Num] AS [JDE Number], [firstname] + ' ' + [lastname] AS FullName," & _ " t_codes.Description AS Title...

I always name the stored procedure with the "dbo." prefix; (i.e dbo.usp_ProjectStaff) is defined as the recordsource. It appears the citrix is not able to find the parameter need by the stored procedure. This parameter is a field on the main form, which gets passed to the stored...

I am running an Access .adp which includes several stored procedures in combo boxes and form record sources. The stored procedures accept form fields to determine which values to return within a combo box or form record source. Under citrix the combo boxes or forms do not return any values or...

After importing an form into a .adp I try to open the form and I get the message "error accessing file." "Network connection may have been lost." I do not get this with every import. It is possible that the imported for may have been related to a linked table. The error...

I recieved the following message in the view history of the Job: Cannot allow BACKUP LOG because file 'XXXX' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup. [SQLSTATE 42000] (Error 4213) Backup or restore operation...

Are there advantages and/or Pitfalls to using SQL authentication with an administrator account for DTSs .vs. just using a windows account for authentication?

I though that was the case. The bidproposal table has null values, which is not acceptable to the bidDisposition table because the bidDisposition does not accept null values as part of the primary key. Thanks you Chiph.

what caused the following error? how might it be resolved? Server: Msg 547, Level 16, State 1, Line 1 UPDATE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_BidProposal_BidDispositionCode'. The conflict occurred in database 'MwbeTsDvlprNew', table 'BidDisposition', column...

I have scores of Jobs on a SQL Server that I would to copy and/or move to a different server. Is there a way to do this without maually re-creating each job from scratch on the new server.

Thanks people. I'm just back from vacation. This will generally work. I'll need to make some adjustments for leap year and some other formatting issues. However, I believe these solutions address the problem.

How can I move my scheduled jobs from one server to another, without having to re-create them?

I have a date which is in the following format "2002105" The first four characters are the year the next three characters are the number day of year. How would I convert this to a datetime format: Example DateFunction('2000032') should return 2000-02-01 DateFunction('2002098') should...