also, for portability of the database do not grant permissions to user/logins grant them to database roles. Then when you restore the database as a copy all you have...

Execute xp_logininfo 'domain\youracountlogin', 'all'

It will tell you all the paths into the server for your account and if it is user or admin permissions.

When it comes to replication I have stopped asking "Why?" or even "WTH? Sometimes when you try a simple schema change it works and sometimes you get errors or...

It is possible that since you are just adding a column that just running the reinitialize with new snapshots after modifying the table will be fine. If that doesn't...

Real time reporting although discussed as a requirement often is really not a practical goal. Rarely can the business react to anything in real time and certainly the cost...

a reporting server that uses links into the production data is a bad idea. Reporting queries, especially ones that aggregate a lot of records from the operational data are...

If you left the database in standby mode then the users (even the new one) will not be able to access the database. If you have taken a backup...

Check the permissions on the folders. When you copied the filestream folder it may not have inherited the permissions from the SQLData folder. The service account needs permissions...

I don't have a copy of PUBS and your desired result is unclear.

Might be something like:

SELECT *

FROM stores

LEFT JOIN Sales

ON stores.<whatever the KEY is FOR Sales TABLE> = Sales.<whatever...

Have you read this article? http://www.sqlservercentral.com/articles/Security/65169/

Especially the part about setting SPNs for each service.

I don't know if it has changed in recent version of windows...

If you use "Exec At" you can use a stored proc with parameters instead of dynamic SQL.

use a CTE or table that has a column of dates you want to include and then left join it to your select statement including the new column of "possible"...

I am not sure what you mean by "add to" but this should update the field to the value you specified

UPDATE PROGRESS_NOTE

SET PROGRESS_NOTE.SUPERVISOR_MONIKER = '699005FE406B40C68B5A5A5DA0090171'

WHERE...

I feel like being Flip today. The answer to the original posters question is: Yes, a query can be written to do that task. :crazy:

When run manually it uses your permissions, when run on schedule by SQL agent it uses the agent accounts permissions. Make sure the domain account that runs your SQL...