Recent content by colinbell

thanks for all your help denny

thanks denny I've got it working but ! I had to amend the SQL server agent for non-sysadmin job running - it asked me for my windows nt details which I entered two things a) where has it stored my details b) my windows ny password will have to change ! how can i amend the details I've...

both servers, on the SQL server agent, are using Windows authentication - do i need to grant the SQLAgentCmdExec account proper login and database permission rights to the SQL Server for the job to run ? sql enterprise manager is version 8.0 if so how do i do that securely ? thanks for any help

thanks I've discovered that someone had restored a table which now has a computed column on it ! sorry about that regards

denny i also notice that, using SQL server client network, the server, i'm trying to connect to, is using TCP/IP which has a network library of c:\windows\system32\dbnetlib.dll which is mentioned in the error message ? regards

Hi Denny Yeah I can connect to it through server console - one strange thing is when i tried to add as an active directory (just as a test) it said error 14353 - cannot determine the service account for this SQL server instance ?

thanks checked that - no options are checked i.e. on

Hi Denny Job History as follows DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or...

Hi I have set-up a DTS local package which, if executed, runs ok there is a job that runs based on the DTS Operating System Command (cmdExec) DTSRun...

thanks SQLBill on another issue - I've used a DTS to create a copy SQL Server objects task for sending objects/data from my staging to live server where it will only ever be that one way. Its created a rowGUID column ? I don't want that - I've already got my own identity column setup is there a...

Hi I've got one SQL server (staging server) with a Database called Internet and a table called membership I've got another SQL server (live server) with the same Database and table. The live server will have the up-to-date data although at times I will need to modify/append the staging server...

thanks your ok genimuse - I'm not insulted - the framework i.e the keyInputDisplay and KeyInputPublish part is a 3rd party product that I'm trying to fit my asp within - I will seperate the validation header stuff from the body when I've got more time..............the product has so many bugs...

Hi I have the code below, which has worked ok up until now. The validation is now not being called - although the rcord still only inserts into the database if all validation is met. What used to happen is if validation wasn't met the page would display, in red, any errors. This is the bit that...

Thanks Ed Yeah I will use the name function to rename the file Richard

Thanks Chaz I've done that and it may have helped. I've also found that it doesn't like the fact that strFileName doesn't have an extension e.g. .txt but i can't have an extension because the company I'm sending it too don't want a file extension !