Hi Simon,

I have experienced a similar problem and it was down to the type of cursor being used. Some cursors will reflect data changes made to the rows in...

I was introduced to Window Functions by Itzik's contribution to the '70-461 Querying Microsoft SQL Server 2012 Training Kit' and my eyes were opened (I wish I'd heard of them...

In the two DBA roles I have held, it has been company size that dictated the scope. Working in the smaller of the two companies, I was employed as...

A bit late for you but to answer the earlier question around the Start button being greyed out for SQL Browser Service, check the Start Mode using SQL Config Manager....

I received a similar error message when running a bcp command from SSMS, however it ran ok from a command prompt.

The SQL Service Account didn't have write permissions...

a bit late for this one but the following steps worked for me (this was configured on the server running SQL)...

Open the IIS Manager, expand your computer's name,...

The DifferentialBaseLSN should equal the FirstLSN of the base full backup. The FirstLSN of your differential backup is quite a bit older then the DifferentialBaseLSN and I wonder if...

you can run the following against the database you are having trouble with to determine when the differential BASE backup was taken:

select name, physical_name, differential_base_lsn, differential_base_time from sys.database_files

the...

Is it possible your full backups are using the 'WITH COPY_ONLY' clause? This will prevent the differential bitmap from being updated & your differential backups will have all changes...

Thanks for spending so much time on this! I did wonder if it was intended but I've some servers that don't respond with the default instance listed - they...

ok, thanks for your replies. Will look at sorting at AD level.