Viewing 15 posts - 15,211 through 15,225 (of 39,970 total)
Log in as the service account and try to run the command.
Or run this:
xp_cmdshell 'dir > \\silverthrone\gadata\IPC\dir.txt'
That will tell you if you can write to that folder. Also, the...
September 23, 2011 at 12:32 pm
SQL Server doesn't need extra space. It needs the space of the files and if they exist there, then that's enough.
It's a security issue. It doesn't matter if you connect...
September 23, 2011 at 12:29 pm
How do you determine which one to keep? note that SQL doesn't order records, so the order you see from a SELECT ORDRBY FROM MYTABLE isn't necessarily what you'll always...
September 23, 2011 at 12:26 pm
Does the SQL engine have permissions to that folder? Or the proxy? This doesn't run under your account, but the SQL database engine service account (or proxy)
September 23, 2011 at 12:23 pm
Grant Fritchey (9/23/2011)
GSquared (9/23/2011)
Grant Fritchey (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history...
September 23, 2011 at 11:15 am
Password Safe is an open source product.
September 23, 2011 at 11:04 am
Can you define what unresponsive means? Are you sure it's the server and not your client?
The inability to process a login usually means there are DDL triggers in place or...
September 23, 2011 at 9:28 am
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
September 23, 2011 at 9:20 am
BenWard (9/23/2011)
People seem to forget that every tool, every...
September 23, 2011 at 9:18 am
Yes and no. You have the right idea, but the problem is that UserA is inside SQL Server. When you execute the CLR, you should still be inside SQL Server,...
September 23, 2011 at 9:14 am
majorbloodnock (9/23/2011)
I've been doing a lot of nodding whilst reading some of these replies.For me, the following are major gaps I see, often in surprisingly senior IT people.
...
Excellent list of...
September 23, 2011 at 9:10 am
You can, but I wouldn't. Is there some reason you wouldn't want to use something like KeePass/Password Safe?
September 23, 2011 at 9:05 am
Thanks for the repost. I'll check those out.
September 23, 2011 at 9:05 am
We did a few things at various companies.
At one, once a year we sent a team offsite (random admins/DBAs/Devs) and gave them backup tapes, media for software, and a blank...
September 23, 2011 at 9:03 am
Viewing 15 posts - 15,211 through 15,225 (of 39,970 total)