Viewing 15 posts - 46 through 60 (of 107 total)
Elliott,
What you have done, retrieving info for each server name, is the direction I have been headed. That gives the advantage of inserting the info into tables that you can...
May 29, 2011 at 11:36 am
Thanks for the good idea, Ninan.
Supposedly (I have not tried it yet), by using Policy-based management, you can schedule it to "poll" or retrieve this kind of information and it...
May 29, 2011 at 10:57 am
Thanks Welsh Corgi.
I agree that it is possible that the backup file is corrupt.
It did not have a .bak extension so I renamed it as .... .bak, then restored.
The restored...
May 12, 2011 at 4:20 pm
Thank you, Jason. Great to hear that. I think it is security settings that are preventing me from accessing the server. I will get that worked out.
February 24, 2011 at 5:24 am
Thanks very much, JasonMorris. That's exactly the tool I have (Mobile manager).
I've not been able to get it to work yet but I will.
One question - Can you see Jobs,...
February 23, 2011 at 7:15 pm
paul.knibbs (2/14/2011)
Silly question: why not just configure SQL server to send job failure etc. e-mails to the e-mail account linked to your Blackberry?
I do that, Paul. I have the alert,...
February 14, 2011 at 11:02 am
Thanks Red Gate evangelist!
February 13, 2011 at 1:38 pm
I would expect the change in performance to be very little.
But you may recover more disk space by changing to variable character columns. i.e. the database may have more space...
November 16, 2010 at 12:11 pm
Thank you Gearge and Gsquared.
I'm enjoying the new features in 2008 🙂
John
November 4, 2010 at 11:32 am
Yes, I was able to download the Hotfix. Thanks for letting me know the site is working!
John
November 2, 2010 at 1:45 pm
Hmmmm. Thank you, Adiga. I will try again
November 2, 2010 at 1:32 pm
Thanks Gsquared and Gsquared!
This is what I have: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
No SPs out yet for R2 - you really helped...
October 29, 2010 at 9:29 am
And this still works ... for 2005.
Thanks very much, noeld!
October 22, 2010 at 12:50 pm
You are correct, Jeff Moden.
I posted the other thread hurriedly, intending to post it to another site that I use. Just got in a rush and should have been more...
May 22, 2010 at 1:43 pm
Thank you, BitBucket! Your suggestion worked perfectly.
SET @sqlcmd = 'sqlcmd -Q '
SET @cmd = '"SELECT LEFT(RTRIM(ServerName),15) as Server, LEFT(RTRIM(LoginName),22) as FailedLogin, LEFT(RTRIM(ClientName),20) as ComputerName, LoginDate from DBA.dbo.AuditDatabaseLogins WHERE AuditType...
May 21, 2010 at 7:14 pm
Viewing 15 posts - 46 through 60 (of 107 total)