This is kind of implied by what the others have said, so I apologize if it was obvious.

I was not apparent in your description when the full backups are performed....

Finding the tables is easy

select sc.name 'Column', so.name 'table'

from syscolumns sc

inner join sysobjects so on so.id = sc.id

where sc.name = 'Employee_ID'

The update could be handled in...

This is one of those difficult areas. To provide convenient service to your users, it is nice to be able to store the numbers. After all, the wallet...

Sure - I am sure you have already considered the performance and security issues. But as far as technology - no problem.

Guarddata-

Sounds like one server is defined as NCHAR and the other as CHAR. The wide character format takes two bytes per character.

Guarddata-

If this is a new column, you can modify your statement to be

ALTER TABLE CAN_MARKET_DATA ADD MRKT_DATA_SEQ [int] [identity(1,1)]

I don't know how to change an existing column.

Guarddata-

If I understand your wishes, it seems like you want to use a subquery...

SELECT col1, col2, ( SELECT min(col3) from othertable where condition ) as col3

FROM maintable

WHERE condition

Is...

I ran SQL on my laptop for over two years with a celeron processor and never had a stitch of trouble.

Guarddata-

We always use TINYINT. Probably a result of version 6.5 handling of the BIT datatype which had problems allowing further changes to the data structure. I agree with...

The main considerations for us have been size and randomness. Just make sure you don't put a clustered index on the GUID things have generally worked well for us.

Guarddata-

...

Thundr51

There may be an inadvertant typoe...try using abbreviations to make it easier to read.

SELECT TOP 100 PERCENT R.FULLNAME, SUM(S.BuyingUnits) AS buyingunits, COUNT(A.[Last])

AS signedapps

FROM dbo.Reps R

INNER JOIN Marketing.dbo.Seminar_Agents AG ON...

I am sure you have done this - so I apologize for suggesting some of the obvious...

If you copy the code directly into query analyzer from the stored procedure, it...

I do appreciate all the input. Looks like I need to spend a little time to learn more about OLAP.

Guarddata-

Wish I could remember the one that produced this a while ago. I can't take credit here.

If you have

DECLARE @numStr

SET @numStr = '345.2300'

then

SELECT @numStr = REPLACE( RTRIM( REPLACE( REPLACE(...

Works fine for me too. I converted both to the format of yyyy/mm/dd and mm/dd/yyyy. Both worked fine. Seems like the format of the short-date on your...