Viewing 15 posts - 91 through 105 (of 469 total)
Peter Trast (5/15/2012)
Don't trust users with infrastructure.
That's a great general rule but there can be places it works well. The trick is that it's going to take work up...
May 15, 2012 at 8:21 am
HanShi (5/15/2012)
I answered this from the top of my head and thought the folder would be visible but not able to expand and/or view.
I was wondering if that was the...
May 15, 2012 at 7:36 am
Are there any indications when it's in single user mode that something is trying to run in that DB? Something may be running in the context of that DB...
May 9, 2012 at 1:47 pm
GilaMonster (5/9/2012)
....
To have a SQL Injection vulnerability requires that some user input be concatenated into an build up string which...
May 9, 2012 at 1:44 pm
GETDATE() returns a datetime type that does include the time. Try this instead to get just the date:
convert(date,GETDATE())
May 9, 2012 at 1:11 pm
One thing you may want to do beyond just the restore is run a checkdb against the restored database. That way you know not only that it restores but...
May 8, 2012 at 2:15 pm
You may also want to check out Securing SQL Server by Denny Cherry[/url]. There's a new edition coming out soon with SQL 2012 and a bunch of other new...
May 1, 2012 at 1:52 pm
I actually have moved to management and then back down at the same company. I and three others got promoted to Team Leads as our support team grew. ...
May 1, 2012 at 7:33 am
Well that's not terribly useful then, is it. There must be something that the app is doing differently than when you are calling it through SSMS. If possible...
May 1, 2012 at 6:24 am
The database name you put in isn't there. Either there's a typo or you're on a case sensitive install. Try putting the name in exactly as it appears...
April 30, 2012 at 1:58 pm
Once they have been restored the backups can be deleted. However, it may be wise to keep them around for a time in case you need to restore to...
April 30, 2012 at 1:56 pm
There is a "Cluster Service" in Windows for a cluster and that may be what they're referring to. If there's any doubt I would ask them to clarify to...
April 30, 2012 at 1:34 pm
If you run the query in SSMS what's the error you get?
April 30, 2012 at 1:11 pm
I'm assuming the update is doing a seek and only updating one row. If not you want to take a look at the query and see what you can...
April 27, 2012 at 10:24 am
How bad is the blocking? If the transaction just has that one statement in it it'll be fairly short lived and shouldn't block anything for long. What's the...
April 27, 2012 at 10:02 am
Viewing 15 posts - 91 through 105 (of 469 total)