Thanks Everyone for the help.
We fixed the issue. we first imported the table to Access and took it to sql from there.
So what can I do to convert it back to date time.
It returned some rows. so this means that all the rows it returned can not be converted. Am I right??
I did that and the out put i got is 0
that means it is not a valid date right??
we imported some tables from informix to sql 2005. we got an error for some tables. the error we got is insert error, column 31('actshipdt',...
I restored a database few days back. I dont have the backup file. i deleted it. Is there any way that i can find the exact date when i restored...
I installed the drivers and when i try to set the properties of the driver and test the connection it says the connection failed because of an error...
we are trying to migrate the informix database to SQL 2005. So can anyone tell me wher i can find the drivers to import the data....
we are trying to import the informix database to SQL 2005. can anyone tell me wher I can get the drivers to import the data.
sorry i posted in the wrong window.
The temp db is not full. so what else might be the problem
Both of them are on the F drive and it has 165gb of free space. do you think i have to shrink the datafiles.
we restrict the data files to grow to a...
it has 165gb of free space.
there is a MP which checks the datbase integrity. it is failing due to the following error.
Executing the query "DBCC CHECKDB WITH...
thank you so much for the help
I deleted the maint plan first. after that when i tried to delete the job it gave me this error.
thanks guys. I fixed the problem
I used the sp_help_job and found out the jobid and deleted that job from sysmaintplan_subplans.
then tried to...
It is giving me the same error even if i use sp_delete_job
The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The...
Separate names with a comma.