Using what was given including the recommendation of converting TEXT data type to VARCHAR you might want to try this:

You will have to insert your own code to update the...

From this web site

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=23911&DisplayTab=Article

Word has no OLE DB provider, so Data Transformation Services (DTS) can't easily access a Word document. Your best bet is to write a VBScript macro to...

SSC is a fine community and its members have helped me greatly, as I am sure it has helped others. My first thought is yes it should expand, and...

Using Sql Server Management Studio

1. Press F8 key to display Object Explorer

2. Right click on the database name

3. Select "Task"

4. Select "Generate Scripts"

5. Script Wizard...

You can use the SSMS (same tool) in the openning window there will be a line for Server name. Click on the down arrow on the right side of...

thought I would expand on my previous reply, and demonstrate how to view what would happen to insure that a deletion using the code is truly what you want .......

Do not know if this will be completely applicable to your problem but here is a technique (found on another SSC forum and being repeated by me) to delete...

As the author of this QOD, and a SQL developer NOT a DBA, I would like to thank all who entered this discussion. I think the question developed a...

From:

http://msdn.microsoft.com/en-us/library/ms188315.aspx

The scope of impersonation is explicitly defined in the statement.

The specified principal is specified as a LOGIN, a server-level impersonation,

or as...

Thank you, thank you ... when I read your last paragraph I actually laughed out loud, now my cube mates are wondering if I am OK or certifiable as...

Now Steve what did you mean to present to us with this editorial? (Pick one or more from the following)

1. A riddle

2. Insoluble problem

3. Inexplicable situation

Wikipedia:

Conundrum, a puzzle or...

Thanks for an Excellent question really rather simply once one understands how partitioning works........... learned a lot from it ...

It appears that most of the posted comments are from IT involved individuals. I would like to point out that companies themselves, if they are to survive, are rarely...

From BOL for 2008

http://msdn.microsoft.com/en-us/library/bb934198(SQL.100).aspx

SELECT SERVERPROPERTY ('FilestreamShareName')

,SERVERPROPERTY ('FilestreamConfiguredLevel')

,SERVERPROPERTY ('FilestreamEffectiveLevel');

FilestreamConfiguredLevel shows the currently configured level of FILESTREAM access, and FilestreamEffectiveLevel shows the effective...

If you are using SQL 2000 the following code should do

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

/**********************************************************

sp_GetBackupInfo without a parameter will report on all databases for a given...