nvarchar can go up to 4,000 characters, you could first try and extend the field length to see if that gives you enough space.

Sounds like you need to profile the server to find out what's writing to the tempdb log.

Your result set...

Check out the fill factor of the table, seems like you may need to adjust it see article:-

http://www.sqlservercentral.com/articles/Performance+Tuning/whocaresaboutfillfactor/1196/

I've never seen this error before but a quick search in Google showed users getting this error when not using the correct schema in referring to the table. Could this...

You can set up the user in the model database with db_datareader, then when a new database is created that user will become a member of db_datareader in the new...

To add also that it will depend on the company you are outsourcing to. Never seen any examples of outsourcing that achieve the expected result, seen plenty of problems though,...

What version of SQL Server are you running with? DTS was for SQL Server 2000, SQL Server 2005 replaced this with SSIS, but still supports use of DTS packages, but...

If you create a view with schema binding, when the underlying table is changed you do get a warning that the view will be altered, which lets you know there...

Having just searched the Internet for inspiration on a schema for remodeling the 'person' in a intelligence system I believe that you will find quite a bit of info out...

This is almost what you want....

CREATE PROCEDURE [dbo].[usp_dbspace]

AS

/*=========================================================================

Stored Proc:usp_dbspace

Purpose:Generates System settings information

Author:Carolyn Richardson

Date:1/09/2007

Description:Lists Database Space used

=========================================================================*/

SET NOCOUNT ON

DECLARE @Result Table (

[DBName] Varchar(100),

int,

Log_Size float,

Log_Space float

)

DECLARE @DBName Varchar(100)

DECLARE @SIZE int

declare...

What happens when you run sp_change_users_login 'report'

if it returns any records run sp_change_users_login 'Auto_Fix'

Will this toolkit be able to find the master record in a fuzzy match say you have a Thomas a Tom and a Terrance will it identify or make a...

Thanks for the article....

Have you done any comparison of your results against the SSIS Fuzzy Lookup Data Flow Task?

Its just that I am working with this problem at the...

I can't see what you are attempting, but you can bring the data into you destination table then do an update on the field as a SQL task ie:-

update table...