If the database does not exists then to restore the database the user must have create database permission but if it exists then user must be a member of dbcreator,the...

See if this helps.

https://support.microsoft.com/en-us/kb/956179%5B/url%5D

Please note the issue occurs only if the user trying to connect is not a sysadmin.In your case if you are a sysadmin and...

Is the SQL server instance 2008 as well ?

What happens when you execute xp_cmdshell in the SQL query window using FakeDomain\FakeDomainAccount login ?

Few months back I had a situation where I had to create instance of class that supported multiple inheritance(MI).C# does not support MI but C++(CPP) does.C# supports MI through interfaces...

This has been a known issue on atleast SQL Serve 2012...

Thank you very much Sir Jeff.You are way to humble given your high stature in the world of SQL Server.

I am glad that I chimed in this post.Made me understand...

Apologies.I will fix it.

Also, instead of using C# to call Visual Basic,...

Jeff Moden (4/2/2016)

Ah... be real careful about using those test results. I've proven many times that using the same row of data a million times as test data (I...

But the Truncate job step will succeed during the other consecutive log backups.It will only fail once when the Full Backup is running which I believe would be only once...

Is there are limitations to no of databases that can be a part of the a group ? Should the no of groups always be 3 ?

DECLARE @t...

Between just stumbled across a very fantastic discussion related to different Split methods for SQL Server.Paul White,Jeff Moden,Aaron Bertrand,Barry Young,Phil Factor(always wondered what his real name is) all these great...

Jeff Moden (4/1/2016)

I can't see the "ELSE" on that and correct me if I'm wrong, but that looks like it might not handle trailing delimiters correctly... which is why I...

The issue with custom text parsing functions in TSQL is that they are very cumbersome to maintain and one needs to be highly proficient in TSQL to very well understand...

Good point -- it would appear that the original query would return Orders as 0 for any client with no orders but the suggested replacement query will surely return 1,...