Then something is happening transaction wise. If you know of nothing then start Profiler to catch transactions in the database to a file or table or just leave open. As...

What is the size of the TL at 9pm? And if is small then something is happening in those hours, you may want to set up Profiler to catch what...

Hey NeoNash sorry I just don't have a box right now I can reinstall to test which sort order collation may do this but if you want the nulls on...

It probably could be done thru code but I have not tried as far as finding. But when you open the transformation it should ask about the bad item and...

Check out the following KB Article about 6.5 upgrade to 7 http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q236989, I bet that it follows suite in 7 to 2000. Most likely Microsoft just assumes that the upgrade...

Hey Jim how did you build your temp table as once xp_cmdshell you are no longer in the same scope as the rest of you query and thus the table...

Not 100% sure what you are trying to do here. What it sounds like is you want to return a dataset with a summed total for 4 columns based on...

Hey Brian I don't believe Access commits in blocks anyway, they are one at a processes to the database. So I don't think it will be an issue however the...

Sorry I find no details on this error in particular nor have I come across it. What service pack is on your server and did you check both the SQL...

Why don't you do backup files of the SQL server and zip them even to really save space then move to the backup server and do a file level backup...

Unless you plan to move right back to 7 then don't worry with the compatibility.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

From BOL

quote:

---

The database being shrunk does not have to be in single-user mode; other users can be working in the database...

This sounds more like you are set to use NT auth and not SQL auth (mixed mode). Check out http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=18452&Queryc=18452&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25 and see if any of these articles help.

"Don't roll your...

Trigger would work best like so. On you table where the null can be allowed or null do something similar to the following.

CREATE TRIGGER tr_PreventDupNotNull ON dbo.tblMain

FOR INSERT, UPDATE

AS

IF EXISTS...

I believe this is the refernce transformation map in the DTS package, open your DTS package and check the transformation mappings.

"Don't roll your eyes at me. I will tape them...