Viewing 15 posts - 9,721 through 9,735 (of 39,769 total)
Looks like security issues. Note that the SQL Agent has to have rights here. The Network Service account doesn't necessarily have rights to get to the files you're working with.
Can...
May 1, 2015 at 9:52 am
The error gives you the problem. You need features enabled on the remote machine.
SQL Server is an application that runs inside Windows. As such, it doesn't have access to...
May 1, 2015 at 9:46 am
If someone is sending you a string and you want to use it as a part of a WHERE clause, you'll need to be sure you use dynamic SQL in...
May 1, 2015 at 9:42 am
1TB, but how big on average? The average size matters more for performance and issues.
If these aren't read often, I might also try to compress them.
May 1, 2015 at 9:32 am
david.gugg (5/1/2015)
May 1, 2015 at 9:31 am
I'm in.
FF for 2015 won't be until Aug, so no real hurry. I think Yahoo is hoping for traffic based on the NFL draft.
May 1, 2015 at 9:28 am
You have to use a T-SQL command. That can be wrapped inside an SMO/PoSh script, but that's what's needed. Shawn has given you a few ways to do that, but...
April 30, 2015 at 10:29 am
I don't like dashboards for storing this stuff. What I'd do is use a process that grabs the backup info and drops it in a small db in Express. That...
April 30, 2015 at 10:27 am
Perry is correct. The hierarchy on an instance is
SMK
- encrypts DMK (master)
- encrypts certificate in master (can be multiples here for different dbs)
...
April 30, 2015 at 10:26 am
I'll drop a note on Twitter, but I doubt it. All the CAS systems I've seen in the past were very, very expensive. As in $100k/appliance. Not something many people...
April 30, 2015 at 10:24 am
It would be nice if failures in a trigger referred to a tran error in a trigger. But what if a trigger calls a sproc and there's a failure there?...
April 30, 2015 at 10:22 am
For the named instances, you should be able to uninstall any of them from setup. You could just delete the binaries and registry stuff, but that's a pain to dig...
April 30, 2015 at 10:20 am
Don't answer here, but feel free to send me a note (sjones at s__s____c____.com)
How would you define data monitor? What does it do? How granular and configurable? I think you're...
April 30, 2015 at 10:17 am
Wayne West (4/30/2015)
I'm curious: how often does Oracle come out with a new major version, or IBM with DB2?
They do it differently. When I used to manage all of these,...
April 30, 2015 at 10:07 am
Viewing 15 posts - 9,721 through 9,735 (of 39,769 total)