the mdf file is open and held open by sql server....only by stopping the SQL Server service would the file date get refreshed....changes happen, but the file is never "closed"...

I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

mine has a list...

if you are lucky, you can hope for a couple of design standards that could make it easier.

IF you can assume that FK columns have the same name as it's...

the CDO object has the ability to send the SMTP user And password, but the default procedure

sp_send_cdosysmail does not have parameters for it;

if you don't have the sp you...

do not cross post the same question in different forums.

follow the thread here:

http://www.sqlservercentral.com/Forums/Topic596429-146-1.aspx

do not cross post the same question in different forums.

follow the thread here:

http://www.sqlservercentral.com/Forums/Topic596429-146-1.aspx

as an example, I'd forget trying to restart the object number as restarting at 1 with a category break, and just generate a number based on Category and item

to...

i don't really like the structure of your table; you are really assuming that you will be inserting the header "T shirts" at the same time as all it's...

can you change the way the data gets inserted? if an application is trying to do an INSERT, can you make it call a stored proc instead?

what happens if the...

the previous link was a 20+ page forum discussion here on SSC;When I used the Google tool, it did not find the thread; I grabbed what items I thought were...

maybe I'm missing something, but i do not see any reason for the looping construction to be in your procedure(which is the reason it is slow)

it looks like you load...

SELECT *

FROM CustomerMapping_Stage

LEFT OUTER JOIN CustomerMapping

ON CustomerMapping_Stage.ClientNo = CustomerMapping.ClientNo

AND CustomerMapping_Stage.Customer= CustomerMapping.Customer

--this finds what is NT in CustomerMapping YET:

--AND CustomerMapping.PKid IS NULL

martina.kenny (11/4/2008)

---

The table structures are as...

check the first link again, I re-edited it; the second link should be fine as well. they just open as a text file; the script is beyond the size limit...

just realized that script does not handle things like varchar(max) gracefully.

here is a link to a 2005 version:

db_documentation_in_html_script_enhanced2005.txt

i got what you are looking for;

there was a script submission that someone made; It creates an HTML document, which you just save and view.

I've enhanced it slightly, and you...