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 !

Actually it deffers very silghtly because the db will need to be put offline to move the file !

The alter db is better because it keeps all dbinfo in master...

check out the new sql2005 keyword Except !

could be something like this...

update Ta

set colx = Tb.colx

...

from ( select * from table1

except

select T2.* from table2 T2

--...

8060 is still the limit for fixed size columns in a row.

Which version of SQL2005 are you on ?

Select @@version

Can you post the original table ddl ?

Indeed,Ahmad Osama, that is the best way (especially because downtime is not an issue) !

(I was just reflecting on that this morning, you know how that goes 😉 )

Or use...

dbv147 (2/6/2009)

---

Hello,

I need to move an index file to another drive and thought I'd get some advice on the best way to do this. The index is on an archive...

It may be fixes with the latest SP. (sp3)

Can you post sqlserver version info ?

Select @@version

On the other hand, if someone has been granted access using windows authentication, it is not mandatory for that person to use the designated software to access the data.

Meaning: if...

0x80004005 usually means "not authorized"

- What's the service account of sqlagent?

- which account is owner of the job ?

- which is the proxy account used in the job ?

- How...

First notice:

[Customer_Business_Subset] starts with a full table scan in stead of an index seek !

([CMS3000_Reports].[dbo].[Customer_Business_Subset].[PK_Customer_Business_Subset])

152802 rows of 49bytes are expected

It wants so resolve [date_deleted] is null

It may be...

This is a SQL2005 forum .... you had better posted this Q in the SQL2000 one.

1) Check books online regarding filegroups and their behavior.

2) If you have control over to...