Viewing 15 posts - 45,181 through 45,195 (of 49,552 total)
Mike Alfa (8/10/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2008 at 1:31 am
Personally I would suggest restore from backup rather than trying to fix. There's no easy way to tell if the attack you got hit with is the same as another...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 11:56 am
And instead of extended stored procedures when working with stuff outside the database (if there's absolutely a need to do that from within the DB)
Jeff, do you know if anyone's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 11:52 am
As I mentioned before, the login used by the application is irrelevant. Anything run by xp_cmd shell is run under the security credentials of the SQL Server Service account, not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 11:41 am
It's justa text file. Notepad works, as does everything else that can read text. The top two lines should show you the version and edition. If not, look at...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 6:23 am
ps (8/9/2008)
How do i do that ? This is a text file which i opened with notepad.
Wrong file. The one you're looking for is called "ERRORLOG". Just like that, no...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:59 am
ps (8/9/2008)
Hi Gail,Sorry i'm not updated with your responses. The moment i finish doing one thing i find newer response from you and i dont cope with your speed.
😀 Sorry....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:54 am
If its talking about expiration period, then its not developer.
Open the error log file. Right at the top there should be something like this:
2008-08-08 17:23:56.21 Server ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:30 am
See my previous post. It's a little pointless setting the connection properties for a service that isn't running.
First thing is to find out why the service isn't starting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:13 am
tazza_no1 (8/9/2008)
I had a similar problem with a couple of databases where the transaction would not shrink even after a successful transaction log backup.
Transaction log backups aren't supposed to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 5:02 am
Ok, so there's something wrong with the service. What's it running as? You can see that in service control manager.
See if you can find the error log (a text file...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 4:58 am
What are you trying to do?
If you're trying to set column names with a variable, it doesn't work that way. What your query is doing is summing the value contained...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 3:27 am
Not management studio. That's just the client tool. The SQL Server service.
Go to Microsoft SQL Server Server on your start menu, all programs. Got to configuration tools and open the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 3:20 am
The latest computer game fad
http://en.wikipedia.org/wiki/Wii_fit
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 2:16 am
Is the SQL server running?
Open surface area config and check that TCP/IP connections are enabled and set to local and remote.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 9, 2008 at 2:04 am
Viewing 15 posts - 45,181 through 45,195 (of 49,552 total)