Viewing 15 posts - 1 through 15 (of 337 total)
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 18, 2016 at 10:01 pm
See if this helps.
https://support.microsoft.com/en-us/kb/956179
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 are trying...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 7, 2016 at 7:31 pm
Is the SQL server instance 2008 as well ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 6, 2016 at 9:04 pm
What happens when you execute xp_cmdshell in the SQL query window using FakeDomain\FakeDomainAccount login ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 6, 2016 at 12:12 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 5, 2016 at 9:21 pm
Kishore M. K. (4/5/2016)
Is this Stop-Start of SQL Service is causing IDENTITY value to jump to lower random value ?
This has been a known issue on atleast SQL Serve 2012...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 5, 2016 at 7:16 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 3, 2016 at 10:15 pm
Jeff Moden (4/2/2016)
P.S. Please stop posting pictures of code. You can't copy the code from those for test.
Apologies.I will fix it.
Also, instead of using C# to call Visual Basic,...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 3, 2016 at 7:34 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 3, 2016 at 7:30 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 2, 2016 at 3:28 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 2, 2016 at 3:08 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 2, 2016 at 2:27 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
April 2, 2016 at 2:21 am
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...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 31, 2016 at 8:36 pm
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,...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 31, 2016 at 7:28 pm
Viewing 15 posts - 1 through 15 (of 337 total)