Search results for query: *

Please tell me if you think this is a good idea. I am storing recurring orders in table A. However when the recurring orders are processed on a weekly basis I want to store the processed date in table B so that I can track all the processed dates for each recurring order. Is this a good way to...

yes I realize that. :) I have to abandon this idea now due to work time constraints. Thanks anyway.... Exams Passed: 70-152, 70-175, 70-176, 70-100

This is a stressfull problem. Scenario: Win2K Server with SQL2000 server on same box. I get an error that says: The code below is using linked server to SELECT from an Access 2003 database. SELECT null as StoryID, TITLE as Headline, AIRDATE AS pubDate, [DESC] AS [Intro]...

...nothing. But if I hard code the date as '03/28/2004' it works! declare @sBeginSunday smalldatetime set @sBeginSunday = GetDate()-@@DateFirst+1 print @sBeginSunday SELECT * FROM CRM_MDB...broadcasts WHERE cast(AirDate as smalldatetime) = @sBeginSunday Exams Passed: 70-152, 70-175, 70-176...

I am finished with my project and all I need is to figure out this error so please help. We have 2 servers. One webserver with sql2000 at a remote location accessed thru VPN and another on the local network with same configuration. On the local machine I scheduled a package to upload TableA to...

yes Exams Passed: 70-152, 70-175, 70-176, 70-100

THIS IS MY HEADER This is the content that I want to extract excluding the header above. THIS IS MY SECOND HEADER This is more content that I want to extract excluding the second header above. Thanks... Exams Passed: 70-152, 70-175, 70-176, 70-100

yes in Word. Exams Passed: 70-152, 70-175, 70-176, 70-100

How can I find all occurences of a string formatted like WE SLATE in bold font and then extract all the sentences beneath WE SLATE and then repeat the process looking for the same pattern again? Thanks and help... :o Exams Passed: 70-152, 70-175, 70-176, 70-100

I am trying to get the ClassName of the Opera browser and then read the url from the address bar but I can't seem to get the name of the address bar. What is it? I am using Spy++ and no luck. Other browsers' address bars are typically called "Edit" but not in Opera. Declare Function...

I already have a view in SQL2000. How can I use that query to return and display in Crystal? Any basics out there for me? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

I already have a view in SQL2000. How can I use that query to return and display in Crystal? Any basics out there for me? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

I had to reinstall IIS because out of nowhere I was getting a Server Application Error on my local Win2000 Prof box when trying to connect to a SQL2000 database in the webbrowser using ASP. Now the previous error is gone but now the SQL permissions do not allow the IUSR account to access the...

yes got it thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

But I don't see the user 'X4355-2000\ASPNET' in the NT list at all... Exams Passed: 70-152, 70-175, 70-176, 70-100

I get this error: Login failed for user 'X4355-2000\ASPNET' I am using C# and the graphical sqlDataAdapter with the DataSet. Now I am accessing a SQL2000 DB. Does this mean that I have to create a .NET account for the DB now? Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

I backed up from the Enterprise Manager Exams Passed: 70-152, 70-175, 70-176, 70-100

thanks but I don't have the original logs. Misrosoft article told me to backup the log file then delete the original and restore from the backup, which I can not do. Exams Passed: 70-152, 70-175, 70-176, 70-100

OK, I am NOT on our production server, thank God! BUT... Our transaction log was full today so I did some research on M$ and they instructed me to backup the logfile and then to delete the ldf file. Well this wacked the sql2000 db. So, I recreated the DB and tried restoring from the...

I need each param parsed out of this string. I am having trouble parsing if the vars vary in length. Data: ec=TTT&oc=CRM&tot=501&UID=88997 (SELECT ID, IP, TID, TheUserDetails.UserID as UserID, --Parsing Querystring, SUBSTRING(Querystring, CHARINDEX('ec=',Querystring) + 3, CHARINDEX('&'...