Viewing 15 posts - 5,011 through 5,025 (of 7,187 total)
I'm sure the search engine you use is as good as the one I do, and I got loads of results for "correlated query". If there's anything specific you...
October 18, 2011 at 3:50 am
Set login auditing to failed and successful logins. You can then get login information from the errorlog. If you want logout information as well, the only way I...
October 18, 2011 at 3:47 am
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
Viewing 15 posts - 5,011 through 5,025 (of 7,187 total)