Did you test the exact example code I posted ?

Can you post the results of this query ?

select count(*) as newcol_NULL_count

from yourtable

where newcol is null ;

Inspect your data !

Your example works perfect as shown next.

create table #mytb1 (col1 nvarchar(50) not null);

insert into #mytb1

Select '500910000000000000'

union all Select '500903000000000000'

union all Select '500909000000000000'

union all Select '500903000000000000'

union all...

nvarchar to bigint requires your nvarchar content to be convertable to numbers !

check your nvarchar columns content for non numeric content or special characters, ...

- Did you design your unit of work for each operation ?

- try to keep your transactions aligned to a single unit of work and commit or rollback as soon...

No. They use the a single...

Maxer (8/22/2008)

---

Sorry, I wasn't clear.

Rights to view all data tables for reporting purposes.

So they can't change anything, but they sure as heck could open up Access or Excel or whatever,...

hengert (8/20/2008)

---

Hi,

I want to add two columns, VARCHAR and DATETIME, to an existing table with data, that are NOT NULL columns.

ALTER TABLE ADDRESS

ADD DATE_LAST_UPDATED DATETIME DEFAULT ??? NOT NULL,

USER_LAST_UPDATED VARCHAR(8)...

"hard coded with week password ... " sounds familiar :sick:

Most of the time, the installers just don't know it is stored in an ini-file or a reg.key.

Search "program files" and...

You can still go multiple instance, but in that case, you may want to have a look at Windows System Resource Manager (WSRM) to avoid one instance starving you server.

For...

I just came across this post which might put some light in the darkness...

http://www.mssqltips.com/tip.asp?tip=1567

http://www.mssqltips.com/tip.asp?tip=1557

just my 2 ct.

I've read somewhere (cannot recall where, but I guess it was in one of Jeff Modens replies) that sqlserver may also experience problems when using between with...

- apparentley you are using SSMS to try to restore the dbs.

It will use the connected instances service account authority to query the backup locations.

With sql2005 that access is restricted...

Indeed, but some people prefer using...

- another reason why it is not a good idea to apply changes without proper inventory and preparation.

You can off course aways generate and execute the sp_refreshview yourself ...

e.g.

Declare @ColName...

the last step of your backup jobs are performing xcopy dos commands to the appropriate safezone.

Because a logbackup may get started while a full backup job is running, that might...