I have source table with columsn, Flight ID , Starting From , Destination. I bring them to a flat file ( i.e to a text file) and then...
I am trying to create a package. I am executing the query select * from db; in the sql query and sending the result to test.
While using the...
I have got a query , which gives the constraints in a database.
select A.TABLE_SCHEMA, A.TABLE_NAME,A.COLUMN_NAME, A.CONSTRAINT_NAME,...
Thanks for the information. I will go through them and check out.
We have got a tape backup software which starts around 2.00 am. on the server and a mcafee anti-virus.
I guess , the tape backup must be going...
It was only the backup going on at night 3.00 AM. So no EM or query analyzer is open.
No , nothing . Its only hourly log backups . Everyday it was going fine. This error occured only yestarday.
Yestarday night we had a log backup failure at 3.00 AM on a sql server 2000. After that the hourly log backup's went on smoothly.
Thanks for the replies.
How can I recycle the sql server error log file and specify the retnetion period.
I can use sPp_cycle_errorlog.
How can I specify the size...
I have got it. Thanks a lot for the help.
Sorry Adriaan ,
I didnot get what you are telling me. Like where I should exactly use X. in the main query.
Can you explain it .
I have two tables PROJECT ( with columns PROJECT_ID , TL , FL , PM )and PROJDATE(with columns PROJECT_ID , delivery_date, Delivered_date). The...
I have got a question. I am running the report using the PTQ.
But it always prompts me for the DSN connection..and the window just keeps on...
Thank you very much . I have got it working.
Hi thanks for the reply..
Might sound silly , but where can I find the option for PTQ.
I am searching for it, but could not figure it out.
I have a query in sql server 2000 , which I should make it work in MS access 2003.
Can anybody help me out in coverting the below query....
There are no other applications running on the Server.
Even today we have got a few alerts. But there are no error messages in the sql error log or...
Not sure. Those have been set before I came and I have never really checked those settings.
So shall I go ahead and change that setting to...
Its a windows 2000 machine with a RAM of 1 GB.
When I run the sp_configure , I see the following settings.
Separate names with a comma.