Viewing 15 posts - 16 through 30 (of 37 total)
Thanks everyone for your replies.
I managed to uninstalled all instance of SQL anything, then reinstall SQL Server 2012 and SSMS 2012. Now I can create, modify, and delete databases...
February 14, 2018 at 3:50 pm
February 2, 2017 at 12:11 pm
Thanks both for your suggestions.
Luis, that's a very neat way of doing it. I'm sure to you it's nothing special, but I'm not quite the SQL guru as...
February 2, 2017 at 10:38 am
January 26, 2017 at 3:49 pm
Lowell's script worked. Since the delete triggers fire in the same session as the stored procedure execution, I was able to get the username from context_info in the trigger.
January 24, 2017 at 12:10 pm
that value...
January 23, 2017 at 11:56 am
January 23, 2017 at 11:02 am
That worked perfectly. Thanks a lot!
January 11, 2017 at 12:45 pm
Cool, didn't know you could do that.
December 22, 2016 at 6:17 pm
Phil Parkin (9/25/2016)
Choose Tools/SQL Server/New Query and then expand the 'local' node to select the connection you are interested in.
When I...
September 26, 2016 at 7:20 pm
According to that query, the default path is c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup
According to SQL Config Manager, the service user for .\SQLEXPRESS is NT AUTHORITY\NETWORK SERVICE.
So I set the permission on...
September 22, 2016 at 9:27 am
Thanks for the response jasona,
I tried setting the path to the default backup folder that SQL Server usually uses:
C:\Program Files (x86)\Microsoft SQL Server\120\backups
...but I get an "access denied" error message,...
September 20, 2016 at 10:31 am
It actually does return 1.
September 15, 2016 at 8:42 am
I inherited this computer when I first started working here. I don't think (LocalDb)\MSSQLLocalDB was installed after that point. I'm pretty sure it was there from the beginning.
September 14, 2016 at 4:31 pm
I found three instances of sqlcmd.exe on my machine:
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\binn\sqlcmd.exe
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\binn\sqlcmd.exe
C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\sqlcmd.exe
Only 110 gave me the 1> prompt that you predicted....
September 14, 2016 at 9:05 am
Viewing 15 posts - 16 through 30 (of 37 total)