Viewing 15 posts - 4,021 through 4,035 (of 7,191 total)
Marco
Please will you post table DDL for prod_starts, along with the CREATE INDEX statement for the index you mentioned? How many rows are in the table? How do...
June 25, 2013 at 8:24 am
Lava
I suppose the advantage of a dynamic port is that a different one is authomatically selected in the event that the chosen one is in use by another process. ...
June 25, 2013 at 8:19 am
The best thing to do would be to set SQL Server to listen on a fixed non-default port, and then reconfigure your application to connect on that port (or reconfigure...
June 25, 2013 at 3:50 am
raghuldrag (6/4/2013)
what was mY error in that?
I don't know - you can see your screen; we can't. But I'd guess that your problem is you don't have an [font="Courier...
June 4, 2013 at 3:50 am
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
Viewing 15 posts - 4,021 through 4,035 (of 7,191 total)