Viewing 15 posts - 12,481 through 12,495 (of 39,936 total)
Sean Lange (5/22/2013)
Steve Jones - SSC Editor (5/21/2013)
May 22, 2013 at 3:36 pm
Grant Fritchey (5/22/2013)
May 22, 2013 at 3:34 pm
Thanks for the update. I'm not sure I would have thought of that, but a great catch.
Did you use some type of hex editor to find this?
May 22, 2013 at 10:06 am
Gary Varga (5/22/2013)
May 22, 2013 at 10:02 am
Grant has a Surface RT. However Sean said "For the Touch I do not have the newer version of the OS. I have the older and much less expensive version."
I...
May 21, 2013 at 4:45 pm
Can you set a login trigger and look for the login from BCP to the instance? I wonder if there's some issue connecting back from BCP.
Can you dir the path...
May 21, 2013 at 4:44 pm
Sean Lange (5/21/2013)
May 21, 2013 at 3:35 pm
You still haven't explained what elevate means. Are they using the EXECUTE AS syntax? Or are they just connecting with these accounts?
May 21, 2013 at 3:09 pm
Lowell has the potential issue. A proxy could do this for sure.
Other than that, I'd still guess it's some weird permissions thing. You could to a
xp_cmdshell "dir > myfile.txt"
and then...
May 21, 2013 at 3:06 pm
I don't have a 2008 SSMS handy to test, but it may not work. It should, but it may not. Are you connecting in a query window or object explorer?...
May 21, 2013 at 11:19 am
I would check permissions. Doesthe SQL Server service account have permissions to the e:\test drive? It likely doesn't by default.
May 21, 2013 at 11:14 am
In most cases, you don't change anything on Windows Server. If there is AV running, you need exceptions for the SQL Server data, backup, log, and error log folders.
All memory...
May 21, 2013 at 11:13 am
When you say elevate access, do you mean people are logging in with these accounts and making changes they can't make from their own account?
I've disabled these in the past,...
May 21, 2013 at 11:11 am
I would agree with David. The service account of the SQL Server database engine must be able to see the folder. By default, the list of folders is fairly well...
May 21, 2013 at 11:01 am
I'd agree with Gail. This doesn't make sense, but I suspect it's a coincidence somehow and not really correlation. Adding indexes is likely to be the best way to speed...
May 21, 2013 at 11:00 am
Viewing 15 posts - 12,481 through 12,495 (of 39,936 total)