Enable cross database ownership chaining between the 2 databases. Create the views using the same owner/schema as the tables. You should then grant select permission on the views...

Did you actually read my reply - I included the correct code. How about trying that !

If Reporting Services is installed using a SQL Server database on a different server, the extended stored procedures won't help you. They can't be used to read the...

You can have...

You are using the wrong syntax

try the following instead

Insert into TblContTitleRef (ContactTitle)

select distinct(ContactTitle) from TblCustomers where TblCustomers.ContactTitle <> Null;

The datalength function returns an integer. The left function returns a character string. SQL Server is attempting an implicit data conversion of the result of the left function...

You could drop the subscription and article on the article that is being used for the table with that you are updating, then apply the same updates and column changes...

It is not good practice to add a user for each and every person who needs access to your database. Wherever possible, use AD groups to deal with this....

Have you thought about what the underlying problem is ?

e.g. is the person not interested in the job they are being asked to do ? is there...

Personally, I would not implement this as a single task. Instead, I would do something like

- create a file watcher process (VB.Net or C# can do this pretty easily)...

Are all of your numbers integers or are they decimal numbers ? I am thinking that you may be converting your numbers to integers which strips off the digits...

This can be done fairly easily. The steps are :

- create query that returns the names of the cities (e.g. SELECT City, 'C:\' + City + '.txt' As CityFIleName...

Not sure whether there are any step-by-step guide out there. It is really a matter of using the article properties to set the name of the sproc you are...

Yes, it definitely is best practice to align your physical disk partitions with how SQL operates. If you don't, you will end up with a system that is working...

yes, you certainly can do it.

Replication is quite happy to use custom stored procedures to apply the insert/update/delete transactions to the subscriber.

So, what you will need to do...