I have created a verity search for our collection of the word documents. Now the management wants to display exact paragraph for the result. Is there any way to search inside the document by bookmarks? Maybe there are some other search engines for the job?
Thank you for your time.
Is it possible to backup data sources from one server to another? I need to move data sources from Coldfusion MX to Coldfusion MX 7 server.
Thanks you.
Our current system – Windows 2000 server with Coldfusion MX and Coldfusion MX7 servers installed. I need to upgrade it to Coldfusion MX7 with Jrun.
I installed Coldfusion MX7 with Jrun, it migrated all settings and data sources with instruction to use the uninstaller to remove the older...
Unrestricted file growth, autogrow is on and 65 gb free space on hard drive. I have set to grow 10% and tried set to 10 mb - with no difference in result.
Space available in the database properties is 0.00MB. Change the Space Allocated in the Data Files tab and the Transaction Log tab doesn't work. Database consistency check produce no errors What else can be done?
Thanks
here us actual stored procedure that I described:
CREATE proc stp_AnalystClassComplete
(@analystLogin nvarchar(10),
@skillID int,
@trainingScheduled nvarchar(10),
@trainingCompleted nvarchar(10))
as
declare @temp varchar(20)
declare @assessmentYear varchar(10)
set @temp =...
Yes, you are correct, thanks!!!
But I have some more work with this - I need to update another table (tblStudentData) data based on the classID, loginName and class date from tblAttendee. How I can update multiple records? I can not use where clause in this case ( at least I don't know how)...
I have to update status of all students registered for class based on classID and names in this class.
here is stored procedure:
create proc stp_AttendeeComplete
(
@classID int,
@loginName nvarchar(20)
)
as
update tblClassAttendee
set attendeeStatus = '6'
where
classID = @classID and...
I have to run stored procedure based on the query - I've done it using cursor, but as I can see from the forum postings - cursor is bad.
Can you help me on how I can reach the same result without using cursor?
create proc stp_completAllAttendee
@classID int
as
Declare firstQuery Cursor for...
I have created DTS FTP package to upload file from FTP site to my directory. It looks fine, executes with no error, I can even see file but at the moment when receiving a message - "Successfully completed execution of package" - file would be deleted from the folder. It looks like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.