It sounds very much like the database isn't quite in single user mode.

If users were connected, I would expect an error message from the restore script.

Is it worth putting a...

Interesting post on corrupted remote backups on LinkedIn recently.

https://www.linkedin.com/groups/Everyone-is-doing-it-Well-66097.S.5930428753128759298?view=&gid=66097&item=5930428753128759298&type=member&commentID=discussion%3A5930428753128759298%3Agroup%3A66097&trk=hb_ntf_COMMENTED_ON_GROUP_DISCUSSION_YOU_FOLLOWED#commentID_discussion%3A5930428753128759298%3Agroup%3A66097

Jeff Moden's response is extremely interesting.

It's not a SQL Server term. I've had it used by Developers, Testers etc to "refresh" their servers. Essentially, restore the databases from production. But that terminology...

A very quick observation shows you have a Fee table and one category would be deposit.

Lets say you insert a deposit value into the Reservations and Fees table and you...

A really old way of doing this was to use dbo.sysindexes and using the rowcnt column.

However, this table is only in SQL Server for backwards compatibility - The other queries...

Are you asking us if you have BI tools installed or how to size your environment to get the best out of SQL Server's BI offerings?

If you want to know...

sarathcd (9/12/2014)

I have a requirement to record all the request urls from our website in the database. I have the option to either insert the url every time a request...

Excellent and fascinating post. More often than not, those who end up in a DBA role have usually come from another role in IT so this a new take...

I did pick the right option. However, all 3 could be the easiest, depending on your coding style.

Alternatively, you don't need the CAST.

SET @boolean = @TrueFalse

works just fine,...

Interesting article. Contemplated this topic previously, but never tried to build it. Looking forward to seeing how you configured this "ugly duckling"!

Could you also post the schema and indices?

What time does the job run and what time are you testing your code?

Is anything else running when the job runs (scheduled)?

Grant beat me to it! Follow that article and you can't go wrong. I followed his advice in a previous role and it simplified management of many servers....

Agree with Jimbo. I'd start with testing out the login credentials or create a login specifically for the subscriber server (not your admin login) and use that instead.

It's a...

Unfortunately, some people like to bask in the glories of others. I had one interview where a candidate bought in a portfolio of his work and while reviewing it,...