urgent? if you had read the chapter or listened to the lecture in class....

in SQL 2000, after the fact, most likely you cannot find out.

if you had profiler running a trace, you can go to the profile....but unless you set it up and...

So as Administrator, it can access the folder with Read/Write permissions, but as it's normal domain rights it can't...I think it goes back to Security permissions on the Folder.

If the...

you need to track changes in the TEMPDB? maybe you mentioned the wrong db?

Are you sure you need to do that? all the tables would get dropped at the...

yulichka (1/6/2009)

---

Thank you for your help, but my db is set to full, what 3rd party software are you refering? When I run your code I get an error:Invalid object...

AFTER someone has already added it? maybe, but probably no. it's possible only under the following conditions:

database recovery model is set to FULL, not SIMPLE...then a third party log reading...

not possible with a single sql statement.... each table updated gets its own UPDATE statement, but it's not hard to put them together as a transaction. both tables can be...

I never try to store a total in a row where the details exist...instead I always use a view that does a sum() of the data in question. Since the...

yeah that's deeply annoying...I'd like to switch it back as well;

my alternative is to sp_helptext functionname/proc/view to avoid the dynamic sql style...but that's a bandaid, not a solution

rename the column.

add a new column with the right name and data type.

update the column to the value where the field was numeric.

update the columns that were not numeric with...

I googled ovl files, and i came up with dos based windows overlay files, or a saved file from Railroad tycoon..neither of which seem to be database related.

can you explain...

yes of course you can have multiple instances...and the instances can be different versions as well;

simply re-run the installation CD or msi...one of the steps is a prompt that asks...

sperry (12/26/2008)

---

Thanks for the reply.

I have changed the path from 'C:\severname\test\ExcelExport.xls' to '\\Servername\Test\ExcelExport.xls' and still the same issue. I can access that from both the server and the local...

sp_refresh view will update the metadata of a view...so if you did a view that had select * in it, new columns will be added when refreshed;

here's a cursor that...

DISTICT gets the distinct items for the columns you selected...if you look at your query results, the only itemt aht changes for the repeated persons that got selected is dbo.SKILLS_DATA.SKILLS_ID,,...