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,,...

double post;

continued with suggestions Here:

http://www.sqlservercentral.com/Forums/Topic625801-1291-1.aspx

can you post the actual query? that would allow us to give an exact answer; for here, i think general suggestions will just lead to more questions and confusion.

stored procs and functions are a little harder to migrate; most of it is manually editing the procs, sorry.

things to look for:

10G uses the standard JOIN syntax, so that's a...

IF your table has a a datetime column with a default value of getdate(), you whould simply use a WHERE MYDateColumn BETWEEN date1 AND Date2; If there is not column...

Here's my first guess, and it's probably right:

when they are coming thru your UI, they are using a different login than when they connect vi SSMS....

if i connect with user...

i think it's Vista;

compared to XP, where every login was also an admin, didn't Vista remove some rights you might expect by default for security purposes? so your login...

do you mean something other than using sp_who or sp_who2?

post the query.

you might be suffering from parameter sniffing, where an execution plan is built on an assumption by the Query optimizer about one or more of the parameters;...

i think what you are looking for is using a CASE and sum together to get the value you are after;

here's a the core example:

[font="Courier New"]SUM(CASE WHEN A.Trans_Type_ID IN ('Reversal',...

15 seconds is a long time, unless it is fiddling with billions of records.

post the query itself so we can see, maybe a missing join or something is killing performance.

saving...