can you post some sample data and table definition ?

brett.davis1 (6/27/2008)

---

View definition as requested:

SELECT RTRIM(ISNULL(Pers_FirstName, '')) + ' ' + RTRIM(ISNULL(Pers_LastName, '')) AS Pers_FullName

, Capt_Order AS Comm_PrioritySorted

, RTRIM(ISNULL(Pers_PhoneCountryCode, '')) + ' ' + RTRIM(ISNULL(Pers_PhoneAreaCode, ''))...

zulfansari (6/27/2008)

---

Thank you Greg, I'm using SQL 2005 and upon right clicking on my table I don't see a Modify option, however I used Design option and I'm able to...

brett.davis1 (6/27/2008)

---

noeld (6/27/2008)

---

Probably on the definition of either one of the tables in the view or the view itself you have exceeded the maximum row-length. The Addiditon of "order by"...

kevin luke (6/27/2008)

---

We have a table that is located in a central SQL Server DB that is currently replicated to a bunch of application-specific SQL Server DB's across multiple servers....

Probably on the definition of either one of the tables in the view or the view itself you have exceeded the maximum row-length. The Addiditon of "order by" is creating...

SELECT a1.*, a2.TAcres

FROM TableA a1

INNER JOIN

(

SELECT acre_id, sum(acres) TAcres

FROM p_acres ...

Glad I could help!

jezemine (6/26/2008)

---

I came to programming from computational physics. In calculations I often used doubles instead of floats. double is probably the least used datatype in sql server.

create table...

Right but then you continue to "articles"->"article properties", right 😉

And yes definitely that was a good catch. I never came accross this because somehow "we" listened to MS advice ;)...

KATHLEEN Y ZHANG (6/27/2008)

---

Thanks Noel. Very helpful!

More questions:

1. You are right, I just tried to add the new distributor and I got 'The server 'abcd' is already defined as a...

Jason Bunn (6/26/2008)

---

Hello,

When I use sp_addarticle to create an article:

declare @pub_name sysname

declare @sql_text nvarchar(4000)

declare @err nvarchar(500)

set @pub_name = 'Acclaim_Repl'

declare @article_name sysname;

set @article_name ='CLIENT_ADDRESS_STD_HIST'

set @sql_text = 'sp_addarticle ' +

...

KATHLEEN Y ZHANG (6/26/2008)

---

Hi, I am wondering if someone have the experience of migrating distributor to a remote server they would like to share.

Currently I have a server that...

RubyRed (6/25/2008)

---

This did not work. Basically I am trying to calculate each minute of an employee time during their work shift. In the table above shows only the...

Are your snapshots using NATIVE mode or CONCURRENT mode. It could be that there is a table lock ( when in native mode) that does not gets released until all...