Viewing 15 posts - 886 through 900 (of 1,413 total)
They work for me, using version 1.0.3. I have checked "Disable WYISWYG Forum Editor (faster page display)" in my preferences for my profile, maybe that is necessary?
May 2, 2005 at 1:36 am
What exactly are you looking for? You can use the function that Jimmy Jen mentioned, STATS_DATE, to get the time when the statistics for the index was last updated. If...
May 2, 2005 at 1:03 am
Well, yes, specifically for setting the user-defined counters that can be monitored using System Monitor. You did not mention if it was those counters you were asking about in your...
April 29, 2005 at 9:10 am
No answer to your question, however I would definitely recommend you to try and getting the April CTP of SQL Server 2005 and Visual Studio 2005 Beta 2 if you...
April 29, 2005 at 9:07 am
Hehe, exactly what I guessed but I thought I'd let you find it yourself.
April 29, 2005 at 7:36 am
April 29, 2005 at 7:32 am
Didn't you have the column filename, containing the full path?
April 29, 2005 at 6:41 am
Just use the timeout properties on Connection and Command.
April 29, 2005 at 4:49 am
Something like this?
SELECT 'sp_change_users_login ''update_one'', ''' + name + ''', ''' + name + ''', ''' + DB_NAME(0) + ''''
FROM dbo.sysusers
April 29, 2005 at 3:04 am
How to ask questions the smart way
You said yourself that you did not have a clue where to look. Colin is giving you a clue to work from.
April 29, 2005 at 1:41 am
Test what? The dll from sqldev.net is a 32-bit dll, so as Mike says it does not work on 64-bit (though he seems to have some workaround). The smtp mail...
April 29, 2005 at 12:54 am
Yes, like I said, SQL Server 7 with Service Pack 4.
April 29, 2005 at 12:45 am
The difference is of course that the row is not locked for others to view. When you are going to update it with new data you check (or rather let...
April 28, 2005 at 9:15 am
Even though it is not good that EM does not show rowversion, it still does not make it not possible to use it. I think you can enter rowversion yourself,...
April 28, 2005 at 9:13 am
If they are not modified then there will not be any locks on them, so I see no reason.
April 28, 2005 at 9:08 am
Viewing 15 posts - 886 through 900 (of 1,413 total)