Thanks for the reply. He tried attaching again then he was getting that same error I mentioned. But he didnt try the second suggestion to rename the files and attaching again....

Both are same. If you check with Show Execution Plan in QA it dont show any diffrence between two Queries. I guess you generated the Query from the Wizard.

--Jeswanth

Try this

where shiftdate > (today - 5 months )

--Jeswanth

Hi,

Did you tried setting the target size for the datafle in DBCC SHRINKFILE in QA or in EM ? or if you solved the same pls share the same.

Thank You

Jeswanth

Hi,

http://www.quest-pipelines.com/newsletter-v5/0204_B.htm 

the link joslyn specified.

--Jeswanth

I feel it will be better if you can install under administrator account and later access by domain account.

Thanks for the information and the guidance Rick.

Why so ? Can you make it clear your statement ?

--Jeswanth

Go to the Em Select the database file goto properties.

set the recovery model simple.

now goto em all tasks shrink database , select files select the log file and shrink.

--Jeswanth

Hi,

You can reverse this techinique and use the same to create datadefinitions in Programming Languages also.

eg: desc table name get the table definition copy paste in excel and manipulate...

Thanks. Derrick Leggett, I will do that for sure.

Hi,

I think i have a solution for you.

Check the properties of the text field and goto paragraph formatting tab in CR.

You can...

Ok I got a vague idea of what you are trying to show in Crystl Report. I feel you are trying to print some special characters in CR . Right...

You cannot Compare two columns unless you write some program in sql server. You can achive teh same by writing a UDF

Hi

Can you provide some sample data ? I cannot understand what exactly you want

/Jeswanth