David,

I will have to confirm this, but off the top of my head I believe Management Studio will generate script for SQL 20005, even if you are scripting a...

Thank you all. I finally got some sleep after a couple of all-nighters. It's amazing how you over look rather simple things with a lack of sleep. ...

Your concerns with auto growth causing a performance hit are correct. Also, you likely do not 28GB data file for 500MB. I agree with all of bbychkov's comments...

Oskar,

Aaron is correct. Do not use a Domain Admin account for SQL Server Service accounts.  Use a Windows domain account in the Domain Users group. 

Also, you said you that...

Mohammed,

Thank you.  It was a contraint violation.  As you suggested above, the task worked after I loaded the tables in the correct order.

Jon

Jim,

In addition to backing up the transaction logs on a regular basis, you may also may want to make sure you are your running DBCC maintenance statements on regularly.  If you...

Jason,

A lot could be going on here, but I will share with you some of my experiences with packages that run unusually slow.  Since it normally only takes 1 hour...

Carolyn,

If you want to use SQL Server to store your data and use Access as the front end to query and create reports from a client work station, you will...

Troy,

I may need more information about your application, so I will have to make some assumptions.  I read your post twice to make sure I am understanding what you are...

I will repeat what Carlos suggested.  For me too, when I have had this problem it is ALWAYS a permissions problem.  Have you confirmed that the service account has the...

I assume the package will execute fine when done manually.  Maybe you already doing this, but you may want to loop through each step of the package and return a...

Carolyn,

I have not experienced this exact problem before, but any time I have issues importing data from one source to another, one of the first things I check is that...

Monte,

What is your ASP code doing. Like Greg said, check your connections.  Can you find anything strange in the Activity Monitor or Event Viewer?

Jon

...in addition to what Jeswanth suggested, also consider using the NO TRUNCATE option when you backup the transaction log.  Read up on it in Books Online.

1.) In Query Analyzer, select "Display Estimated Execution Plan" from the Query menu.  Take a look at these articles to help:

http://www.sqlservercentral.com/columnists/RDyess/displayingexecutionplans_printversion.asp

http://www.sqlservercentral.com/columnists/rmarda/performanceaddinghints_printversion.asp

2.) Yeah, it doesn't look like there is...