Count(some_column) does not work with certain datatypes eg. uniqueidentifier

Hi Rahuul,

Have a look at merge replication, you need to create a publication on the central database and then create subscriptions to that db in MSDE

The RowGUID is how SQL Server identifies each row and keeps track of changes made to it, if u add them yourself, then u can have control of the name,...

Hi,

If you want to use joins, then try this

SELECT     A.AccIndex, A.RegionCode, A.CostCentreCode, A.CostTypeCode, B.YearID, B.MonthID, B.TotalBudget, B.TotalActual

FROM         dbo.FinAccount A LEFT OUTER JOIN

                          (SELECT     COALESCE (Budget.AccIndex, Actual.AccIndex) AS AccIndex, COALESCE (Budget.YearID,...

You could allow subscriptions to be created by attaching a copy of a subscription database, create a subscription at head office then copy the subscription db to CD and send...

Not really sure why u don't want a function or sp in your db, but try this

Select Len('a,b,c,e,3') - len(Replace('a,b,c,e,3',',',''))

this assumes that you don't have any embeded spaces in the...

Check out this link

http://www.sqlservercentral.com/scripts/contributions/1099.asp

Check that you have chosen the not for replication option for the identity column

You need to be looking for copy subscription database in BOL, this will create a compressed copy of the database which can be reattached at the other end, in our...

You could link to the tables using ODBC, and then loop thru them running a make table query for each, but DTS should be quicker

Hi Avi,

If you install MDAC on the client computer, then cliconfg.exe will be installed as part of this.

You then have to create an alias for your server, call it what...

You only have to change the connection information if you want to use the same file, but I find it easier to use one db with a meaningful name and...

Hi Avi,

As far as I'm aware, cliconfg.exe is part of windows, and it resides in the winnt\system32 directory.

The hosts file is located in \WINNT\system32\drivers\etc

Hi Avi,

For the client configuration side, enter "Setting Up Client Configuration Entries" in the search panel in BOL, once you have set up your alias, you can put an entry...

Try setting up an alias using cliconfg, and putting an entry in the hosts file