One thing you can do is to shrink your log file. Since your recovery mode is Simple, you should be able to shrink the size of your log file...

I was searching for an answer for this error message and I found the following link that might help others:

http://www.sql-server-helper.com/error-messages/msg-117.aspx

Here's a user-defined function that counts the number of words in a given string:

http://www.sql-server-helper.com/functions/count-words.aspx

Here's a link that discusses three different way to avoid the Division by zero error:

http://www.sql-server-helper.com/error-messages/msg-8134.aspx

To get the actual name of the day instead of the number, you use the DATENAME function:

SELECT DATENAME(DW, GETDATE())

Hope this helps.

SQL Server Helper - FAQ - About Dates

http://www.sql-server-helper.com/faq/dates-p01.aspx

You may also want to look into the following link which discusses a similar situation:

http://www.sql-server-helper.com/functions/comma-delimited-to-table.aspx

You just need to remove the single-quotes in your comma-delimited values to make it...

You may also want to look into the following link which discusses a similar situation:

http://www.sql-server-helper.com/functions/comma-delimited-to-table.aspx

If you want to do some aggregation on your data, grouping it by weeks, you can get a function on the following site that will give you the start of...

Here's a link that has a user-defined function that returns that first day of the week for any given input date:

http://www.sql-server-helper.com/functions/get-first-day-of-week.aspx

To use it to count for the number of...

Here's a link that shows a user-defined function that will encrypt any string using a simple algorithm:

http://www.sql-server-helper.com/functions/string-encryption.aspx

I emphasize on the word "simple" because if you look at the algorithm...

Here's a link that will give you other ways of getting just the date part of a DateTime data type:

http://www.sql-server-helper.com/functions/get-date-only.aspx

As to why it stops inserting after 32700 rows, it's possible that data being inserted to the Address table or Address_View view contains duplicate records on the HouseholdID and ContentTypeID.

To give...

The problem is you are using the Alias ([Sales], [GP] and [Set Disc]) in your computation, which is not allowed.

One suggestion that I can give is to create a temporary...

One option that you can do is to detach the database, copy all the database files as another name, attach the original database, then attach the copied database using a...

You can try this:

SELECT     [4gl Datamart].dbo.tmp_D_Customer.cust_sys_num, [4gl Datamart].dbo.tmp_D_Customer.cust_num, [4gl Datamart].dbo.tmp_D_Customer.cust_name,

                      [4gl Datamart].dbo.tmp_D_Customer.cust_territory, [4gl Datamart].dbo.tmp_D_Customer.credit_limit

FROM         [4gl Datamart].dbo.tmp_D_Customer

WHERE NOT EXISTS (SELECT 'X'

                  FROM [4gl Datamart].dbo.test_D_Customer

                  WHERE [4gl Datamart].dbo.tmp_D_Customer.cust_sys_num = [4gl...