My understanding is that it only deletes the one that have an expiration set, ones before you set the expiration do not get deleted by the maintenance plan and have to...

Consider you ASP page, could be something wrong in it.

If it were the firewall more than likely you woulkd never get data, firewalls generally don't cause slowdown in connection,...

Is the above DDL copied from Enterprise Manager?

I run the whole thing without any issues.

A thought thou, is there data already in the table? If so what is the highest...

No it doesn't.

Don't know. Crystal 8 never gave me any issues trying to access stored procedures. I still have the code for passing in parameters and all currently in production with 8, although...

Unfortunately I ca only go right now on what I read and not able to test the items I read as I don't have anywhere I can run RoR right...

The top 1 will specifically give you just one record for the entire set which may not match anything. However I cannot decern enough infomation from yuor titles to help....

Again not sure based on the wording what they are truely asking

5. I have dropped a table from the database ,but ,when you execute sp_help, it shows you the table. what is the...

Confused by the wording of this one

3. Do we Call a View in a procedure ? if yes ,will it raise cartesian product or   not ?

A view is used like a...

Be carefull of this one

2. You can always find the rowcount from sysindexes in each database, regardless whether or not a table has any index on it.

Many people overlook this...

Also, do you need a historical reference of address, then altering the middle table with a date field to serve as your end of use date may push you to...

It may not actually be done with everything. Try stopping the job and see what messages the history has in it then. Or you may have the job on success...

It stores the transaction information records for recovery. You cannot keep it from growing but if you don't have a need to ever need to recover transactions since the last...

Many companies have rules around determining if a contract should be renewed and ways to end it. I was with Travelers for home insurance (had been for 5+ years) when...

Did you upload the connection object for your report? Check the online report manager and folder related to your object to see the connection.