HanShi (2/11/2009)

---

As ALZDBA allready told, 8060 is the maximum number of characters that fit in NVARCHAR. If you really want to convert the NTEXT you must limit the amount of...

If you were on CU10 or 11 of SP2, I'd suggest you go on to CU1 of SP3 to get to the same software level.

It's always nice if some one makes life easy for you. 😎

As always, adding default values for columns is something that depends on the needs of your data model !

If...

As Chad stated, there is a CU1 for SP3 (released at about the same time as sp3 itself).

To apply it to a SP2+CU10 (or CU11), you can directly apply SP3...

You just need to start it. No configuration needed.

Just be sure you use Local System service account !

(just as a best practise. In clustered env. you need it to be...

We run AV on all our servers.

For db servers we exclude the db file locatons as well as the location of the backup files.

We recently had an issue with one...

You need to start SQLBrowser service for your applications to be able to find and use the instance.

(unless you connect directly using the actual port number)

Although Greg's solution works, you should still pose the question if you need to do this in a query!

Presentation should be handled at the front end application !

(one of the...

Did you try :

declare @begin datetime, @end datetime;

set @begin = getdate() - 1 -- dateadd(hh,-1,getdate())

set...

synce you run the sproc in parallel

and you create objects,

I'm not surprised you run into conflicts.

At least at catalog level (creating the objects, indexes,..).

gharris_35 (2/9/2009)

---

OK Crated a script that converted the NCHAR fields to NVARCHAR fields BUT it fell over when the data was reinserted back into the table. As I had...

ehm .... Microsoft SQL Server 2005 - 9.00.1399.06 ... thats RTM ! (+- 3 years without maintenance ??)

There are a number of fixes available and solved with SP3 (=current)...

hmm ... well normalized schema :sick:

Looks like someone migrated from access or so...

Let's see what we can do ... I'll be back 😀

.. to ensure the left join has a match....

i.e. only handle inner join stuff ...

Still...

Is there any credential mapping ?

Local system does not have auth on other servers !