Have you checked whether the user is aliased to dbo on any databases? run sp_helpuser against each database - it will display a list of aliases and, in a...

2km (5mins) commute each way - if there are traffic problems then add another 5mins max. Traffic-related stress relieved by a walk along the beach after work :w00t:

Right-click on SQL Server Agent and go to Properties

Click on "Alert System" and make sure that the checkbox for "Enable Mail Profile" is checked - then select a suitable DB...

I've found Access Projects have exhibited unexpected behaviour before - including data access pages (DAPs) that become corrupt for no apparent reason, and then have to be recreated. The strangest...

Agreed, triggers are a bit of a...

how about creating a trigger on 'myTable' for inserts, and creating a separate 'audit' table

When a new row is inserted into 'myTable', insert a row into the audit table with...

SELECT TOP 100 PERCENT FROM viewname

Hi Steve - that's what I was trying to say :w00t:

bear in mind that if you backup accross the network, there is a risk that the backup could be corrupted if there is a network glitch - so it may...

have you checked the properties of the data source once its been deployed to the report server? For comparison, on the report server, I have the following set up for...

when you deploy your report do you also deploy the datasource?

In Visual Studio, if you right click on the project and select 'properties', then click on 'configuration properties | general'...

try this

Open the report inside Visual Studio

On the Data tab click on the three dots next to the "Dataset" dropdown list. This will open the Dataset dialog box.

Click the...

...or if that doesn't work...

:w00t:

SQL pick up line...:w00t:

Database Analyst is a useful job title as well...just my 2c 🙂