Viewing 15 posts - 15,346 through 15,360 (of 39,824 total)
Robert Davis, head of the SQL Server MCM program, says it's a keyword, just not reserved.
August 11, 2011 at 10:05 am
2K8 is turns blue, but works fine. Not sure why. "Batch" isn't blue.
My guess is it's a mistake in the config for SSMS. I'll ask around.
August 11, 2011 at 9:36 am
tbailey 19088 (8/11/2011)
You ask if a copy of the database encryption key is needed to restore a backup and then you answer that a copy of the server certificate...
August 11, 2011 at 9:33 am
schema has nothing to do necessarily with permissions. Roles can do that. Schemas are for object organization. You can use them for security, but there's no need to do so.
August 10, 2011 at 6:11 pm
Food is OK at Coors Field. Nothing special from what I've seen. I seem to remember that the AZ park had a lot of choices.
August 10, 2011 at 4:37 pm
narasimhareddy.dba (8/10/2011)
yes, we are getting the alerts from server xyz like<xyz>backup job failed from XYZ server.
please asist how to aviod those alerts from XYZ server.
That message in no way requires...
August 10, 2011 at 4:35 pm
Users do not need to own anything, objects or schema, to access them.
Use a roles, grant the appropriate rights to the role for the object(s). In your case it looks...
August 10, 2011 at 3:19 pm
I'm guessing that there is some type of third party tool that kicked off a trace.
August 10, 2011 at 3:17 pm
You can use any method, just set a peak size and leave it at that.
August 10, 2011 at 3:12 pm
For databases in full or bulk logged modes, you need to run log backups. That is the only way to backup the log records and reuse the space.
The log size...
August 10, 2011 at 1:41 pm
We are looking to do more with HTML 5 in the future, which might help as well.
August 10, 2011 at 1:15 pm
Brandie Tarvin (8/10/2011)
This one is giving me heartburn. I almost ran something in Production that was supposed to...
August 10, 2011 at 12:08 pm
It's possible, but I doubt we would spend much time on this. Ultimately we don't expect you do use the code from the iPhone since a cut/paste doesn't make a...
August 10, 2011 at 11:54 am
I have updated and corrected the script and included a create database statement. This does show fragmentation of .39% and 90+% if you run this in a newly created database...
August 10, 2011 at 10:29 am
Viewing 15 posts - 15,346 through 15,360 (of 39,824 total)