Viewing 15 posts - 9,016 through 9,030 (of 13,469 total)
i think you'll want to use a monitoring software package that tests the server and the services that exist on it; you can't relaly expect the server to monitor itself...
July 22, 2010 at 6:22 am
well I know about the listening port for SQL Server...the other services, I'll await other more knowledgable users to chime in.
the default instance uses port 1433 until you change it.
additional...
July 22, 2010 at 5:55 am
well, i'm confident you didn't misspell the user, so here is my best guess:
the user Fateme_Hei is probably already a sysadmin. that LOGIN does not also have to be a...
July 22, 2010 at 5:39 am
okiftequar (7/22/2010)
Exception Message: Could not connect to mail server. (No such host is known).)
that error is usually because the url to the mail server is incorrect, or there's no...
July 22, 2010 at 5:28 am
here's the default trace scripted out so you can see and add more events, etc and create a replacement that might last longer than the default:
July 22, 2010 at 4:27 am
also this part:
'The service queue "LoggingQueue" is currently disabled.'
you have to kick everyone off of the database to run the script to set up the queue; exclusive access is required....
July 21, 2010 at 5:01 pm
I'd think sa has access to everything if it exists...
if you don't filter by application name, your hours using the ERP will be inflated for developers who connect with SSMS...
July 21, 2010 at 4:57 pm
rule of thumb for me is if the @TableVariable has anywhere near 1000 rows or more, it should be changed to a #temp table instead...
after that, it would take some...
July 21, 2010 at 4:52 pm
the security part that is tripping you up is this part:
@useself=N'True'
that means when you select from the linked server, your sql login is being used as the credentials for the...
July 21, 2010 at 4:47 pm
ron morgan (7/21/2010)
July 21, 2010 at 1:53 pm
after setting up that logging demo example, this query gets me the groups of login/logut elapsed times: note i am testing for a specific application name. i could then...
July 21, 2010 at 9:59 am
can you infer that ALL logins are only used for the ERP program?
a login does not know what database you are connecting to...the login happens before all that.
assuming you are...
July 21, 2010 at 9:16 am
you mean the first and last login per day?
once the data is in the table "Logging " fromt hat article, you can easily create a view that might do...
July 21, 2010 at 7:42 am
Martin one of the things you can do to get a better look at what SQL is doing behind the scenes is to look at either the Estimated Execution Plan...
July 21, 2010 at 5:55 am
Oracle_91 (7/21/2010)
July 21, 2010 at 5:44 am
Viewing 15 posts - 9,016 through 9,030 (of 13,469 total)