Viewing 15 posts - 5,011 through 5,025 (of 7,185 total)
If it's not listening on the default port (1433) then, as Dev explained, you will need to supply the port number when you connect - something like this: MYSERVER,9999. ...
October 18, 2011 at 2:32 am
colin_sloss (10/17/2011)
Is there a way to actually move a table to the secondary filegroup?
Dropping a clustered index and recreating it on a different filegroup will move the table to that...
October 18, 2011 at 2:02 am
Is it a default instance, or a named instance? SQL Server Browser will only resolve named instances, as far as I know.
John
October 18, 2011 at 1:20 am
If you search for the error message on the internet, the first result is a comprehensive-looking Microsoft article on this. Have you worked your way through that?
John
October 17, 2011 at 7:49 am
martin.kerr 34088 (10/17/2011)
well i havent changed any of my passwords on my local machine or on any servers or any sql instances
Yes, that's my point. Has the password expired...
October 17, 2011 at 7:39 am
I have seen this error when a password for a Windows account has expired but has not been changed. Is that the case with your login?
John
October 17, 2011 at 7:25 am
forsqlserver (10/17/2011)
Guest is a login not a user...
That's interesting. What do you get if you run this?
SELECT [name] FROM master.sys.server_principals
WHERE type_desc IN ('SQL_LOGIN', 'WINDOWS_LOGIN')
John
October 17, 2011 at 5:25 am
As far as I know, a constraint only applies to a single row. In order to do what you require, I think you'll need to use a trigger.
John
October 13, 2011 at 3:37 am
Well, I don't agree with you on that, but we can agree to differ. So my question becomes this: why do you need dynamic SQL at all? Can...
October 11, 2011 at 9:05 am
Do you need to use dynamic SQL at all? For the example you gave, it sounds like a simple stored procedure, with parameters but no dynamic SQL, will do...
October 11, 2011 at 8:46 am
One question answered out of three, so I'm still guessing. Here's what I can tell you:
(1) Your SQL Server service account needs to have a login on the remote...
October 11, 2011 at 1:33 am
Why have you removed the -E switch? Are you running the command interactively, or is it running in a job step? Is the server you're trying to connect...
October 10, 2011 at 7:30 am
Raymond van Laake (10/7/2011)
it finishes within a second or so, with an error
The error message would assist with diagnosis of your problem. By the way, you don't need the...
October 7, 2011 at 6:29 am
L' Eomot Inversé (10/7/2011)
Now that you mention it, that certainly looks like a possible explanation. Much more likely than a spontaneous improvement.
Yes, that and the fact that Steve added...
October 7, 2011 at 6:20 am
Connecting to the wrong server? Caps lock on? Fat fingers? You're really going to have to work this one out for yourself, since none of us know...
October 6, 2011 at 8:27 am
Viewing 15 posts - 5,011 through 5,025 (of 7,185 total)