Viewing 15 posts - 4,021 through 4,035 (of 7,187 total)
Wow! You're right on 3. We're eventually in agreement on everything.
John
June 4, 2013 at 2:35 am
opc.three (6/3/2013)
Not sure I understand...
Right. And that Login is sa and that cannot be changed.
When I create a new database from my own login, which has access through its membership...
June 3, 2013 at 8:30 am
opc.three (6/1/2013)
When the Login is a member of sysadmin this happens regardless of whether the Login has a User in the database or not.
But dbo is a user in the...
June 3, 2013 at 2:18 am
RichardBo (5/28/2013)
I have a server where there are logins created that are mapped to dbo in a database.
Only one login can be mapped to dbo in any particular database. ...
May 28, 2013 at 6:40 am
sahoong (5/24/2013)
Hello,Could someone tell me why a job could be reported as 'succeeded' under maintenance plan history but 'failed' under SQL Agent job history for the same job?
Thanks.
One possible reason...
May 24, 2013 at 4:25 am
niladri.primalink (5/24/2013)
Yesterday I installed 2012 and trying to know its features. Here I am facing a problem. I am trying to take back up of my AP database in...
May 24, 2013 at 3:00 am
Your best bet is to use some monitoring software such as SCOM (others are available). If you have to roll your own, I think you'd need to create a...
May 24, 2013 at 2:45 am
I'm really not an expert on this, but what jumps out at me is that there is no path to the file in your connection string.
John
May 24, 2013 at 2:09 am
OK, so that suggests to me that the problem is with the Excel connection, not with the ForEach container. What is your connection string, and have you tried using...
May 24, 2013 at 1:24 am
jhager (5/22/2013)
Upon further digging, I've also come across a large number like this:
...
There are (currently)...
May 22, 2013 at 7:11 am
We do most of our backups across the network. The advantages are as follows:
(1) Don't need to duplicate disk space on local server and on backup repository share.
(2) Backing...
May 22, 2013 at 1:28 am
kevaburg (5/21/2013)
Your definition of "easier" is somewhat abstract in my opinion but then that is a personal opinion.
Example of mapped drive restore (assuming you even have access to use xp_cmdshell):
EXEC...
May 21, 2013 at 8:52 am
I've never used NET USE when restoring backups. The only way it would work is if run in the context of the service account, which would mean a two-stage...
May 21, 2013 at 7:07 am
Well, if you do that, you're going to use that bandwidth up when you do the copy instead of when you do the restore, so I wouldn't worry too much...
May 21, 2013 at 6:33 am
Divide by 100000000.0 and cast as decimal.
John
May 21, 2013 at 4:03 am
Viewing 15 posts - 4,021 through 4,035 (of 7,187 total)