Search results for query: *

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

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.

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

Within the next two weeks I will begin the process of migrating database server to a new Windows 2000 platform running SQL 2000 from a Windows NT platform running SQL7. I have three SQL servers. Two of which are running MDAC 2.5 and the other running MDAC 2.6. I have a number of DTS Job running...

Email notification have worked for Job in the past. I check the SQLserverAgents on both servers and they ar running. I have tested the mail profiles on two servers. The session in the test appear successful. However, when I view the error logs I get the following errors. Server1 [260] Unable...

The job ran previously. I only changed two field transformations and tried to re-run the job. It failed. I ran the DTS and it succeeded. I get the following error when I try to run the job. ... DTSRun: Executing... DTSRun OnStart: Delete from Table [XXXXXXXX].[dbo].[YYYYYYYY] Step...