The script is failing because what you are doing is not right, because reports deployment problems comes from setting of permissions and moving the ReportServerDB and ReportServerTempDB.  The developed reports are...

Hi Richard,

The First is what is causing it you need to start a new report and either add your fields manually through expression in the tables details section or try...

If you want to extract and store use Greek collation, attach Word not really but IMAGE column store Word and PDF almost like attaching because your file will be inserted...

If your files are Word documents that changes your needs because Word is best stored in IMAGE because all other data types you could loose formatting. The IMAGE data type comes with...

If the cast to varbinary will solve the problem it could also imply varbinary column could solve character conversion problems, a few weeks back a user picked my collation solution...

You have more than the minimum the SQL Server installer may be confused, try installing the Advanced it comes with all the features of regular SQL Server except the Agent. ...

Create blank databases and use DTS to copy your data back, all other solutions will not return your original databases because the product changed in many ways.  Hope this helps.

(Basically SQL Server just takes the UTF-16 representation, and stores that in the row record)

(select a, cast(a as varbinary(20)) from alma2)

SQL Server does not use UTF16 it uses UCS-2 which...

Actually that is not correct because being Nvarchar just tells SQL Server the data is not ASCII it is the collation that tells SQL Server what language to store with...

To calculate PI you need float data type to get correct results and to store the symbol in  Nvarchar you need to make the column collation Greek, you are getting...

No it works just not fully documented, using proxy account with the Agent to move data from one location to another worked from SQL Server 7.0.  There are issues not...

The SQL Server team created a toolkit to help you deploy your database to a hosting company all you need is an account.  There is a two part tutorial of...

Mine was an alternative to sqlcmd.

Try these

http://www.codeproject.com/vb/net/SQLAgent.asp

http://www.lazycoding.com/products.aspx

http://www.sqldbatips.com/showarticle.asp?ID=29

http://www.sqldbatips.com/showarticle.asp?ID=27

You cannot drop a foriegn key with DRI(declarative referential integrity) constrant because the CASCADE UPDATE, CASCADE DELETE, CASCADE SET NULL and CASCADE SET DEFAULT if all are enabled must be dropped before...