Viewing 15 posts - 5,011 through 5,025 (of 7,191 total)
OK, and during execution, what colour are the two data handlers when your data flow gets stuck on yellow?
John
October 18, 2011 at 4:33 am
What does the event handler do? Is it possible that the task is still yellow because the event handler is stuck doing something? You may wish to experiment...
October 18, 2011 at 4:27 am
Another thing that's worth trying is backing up the database and restoring to the new location. This should obviate the need to delete the subscription. Vultar's advice still...
October 18, 2011 at 4:09 am
Is Google broken today? Do your own research, and post back if there's anything in particular that you don't understand.
John
October 18, 2011 at 3:53 am
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
Viewing 15 posts - 5,011 through 5,025 (of 7,191 total)