Viewing 15 posts - 61 through 75 (of 107 total)
I've try that and I always seems to miss the window. Is there a way to look at the log some other way?
March 28, 2013 at 8:15 am
I can believe I'm posting to my own question, but I think I find the problem.
If I ran the following sql statement:
SELECT SUSER_NAME([owner_sid]), SUSER_SNAME([owner_sid]) FROM [sys].[databases]
I get two columns, the...
March 27, 2013 at 10:39 am
Thanks the article was helpfull. I ran some scripts against the tempdb and got the following:
SELECT [Name], [Size]*8/1024 AS [File Size in MB] , , [Physical_Name]
FROM master.[sys].[master_files] AS...
March 13, 2013 at 10:36 am
I ran DBCC UPDATEUSAGE on the tempdb and the negative space is still showing up. Somehow my database file has reached close to 4GB, last few days we have...
March 13, 2013 at 8:25 am
SQL Injection attacks are very present and as the article mentions they are still around because developers either by lack of knowledge or experience are still programming to allow these...
February 18, 2013 at 10:03 am
Oh my, when I think of looping through a record set I automatically think about cursors that was the first approach I learned for looping. It's going to be...
February 8, 2013 at 7:53 am
I'm very new to TSQL so my apologies for my lack of experience. Really working on it : ) So instead of using a cursor what would be...
February 6, 2013 at 7:03 am
Maybe you could use the sql statement below:
update tablename set column3 = column1 + column2
February 5, 2013 at 7:06 am
The account does not have administraive priviledges on the machine. Also, how do I check for 'Remote registry' access?
January 31, 2013 at 7:05 am
Attached are some images. I hope that gives you enough information.
January 30, 2013 at 7:12 am
If I play around with the email settings I get that function working properly. However, I still see the entry logs entered when I try to restablish the server...
January 29, 2013 at 3:39 pm
I believe I got that error taking care of, now I'm able to login, however I cannot start the monitoring of the servers below it's what gets writting to the...
January 29, 2013 at 3:16 pm
One thing I want to mention is that when I ran all the tests listed in this page (http://www.red-gate.com/supportcenter/Content/SQL_Monitor/help/3.2/SM_Testing_data_collection) all work except the WMI. If I use...
January 29, 2013 at 7:21 am
I just tried to restablished the connection and this is what was written to the log, please see below. One more thing that I believe is important and...
January 28, 2013 at 7:23 am
Viewing 15 posts - 61 through 75 (of 107 total)