Viewing 15 posts - 37,471 through 37,485 (of 49,566 total)
True as long as the OS isn't Vista or Server 2008. In both of those, builtin\admins no longer gets added as sysadmin. Also the case on all SQL 2008 installations.
July 24, 2009 at 6:05 am
SQL 2008 has no problems with 2005 data files. It will convert them to 2008 format the first time they're attached. Once that conversion is done, there's no going back...
July 24, 2009 at 2:51 am
SQL ORACLE (7/23/2009)
I got the same error except I was doing full backup. What is wrong then?
That error shouldn't be possible on a full. Diff, yes, log, yes.
Can you...
July 24, 2009 at 2:17 am
hugh.hemington (7/23/2009)
I do see something about "SQLAgent - Enabling/disabling Agent XPs" I'll look that up and see if it is an issue.
No, that's just the SQL agent procs getting...
July 24, 2009 at 2:00 am
Several possibilities
Someone ran DBCC FREEPROCCACHE
A database was closed, taken offline or restored
An sp_configure was run. Some options flush the proc cache
July 23, 2009 at 1:43 pm
Login names are easy. Query sys.sql_logins. Passwords, on the other hand, are stored hashed within the master database and are not queryable.
Can you explain your problem in more detail?
July 23, 2009 at 1:42 pm
DBA (7/23/2009)
can you update stats online in enterprise?
Statistics updates are always 'online'. There are no locks other than a schema stability lock taken by a statistics update so the table...
July 23, 2009 at 1:40 pm
"I Am Legend"? The book, not the movie. Might be a little dark for the age that he is.
July 23, 2009 at 12:50 pm
If you don't like QWERTY, try this - http://gizmodo.com/275582/
I love touchpads. Always use the touchpad on a laptop rather than packing a mouse and I have a fair-sized graphics tablet...
July 23, 2009 at 12:00 pm
Try this for starters
http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/
Recovery is only necessary when the DB has not been cleanly shut down, usually the result of an unexpected, sudden shutdown of the service or the server.
July 23, 2009 at 11:52 am
hugh.hemington (7/23/2009)
It's on a Server 2000 system, that is a domain controller running active directory (done to satisfy this stupid software), and it's just me using it.
Running SQL on a...
July 23, 2009 at 10:24 am
I use Logitech for both keyboard and mouse. Got the logitech G11 keyboard. Lovely keyboard, very large but quite flat and very soft touch. i barely have to touch the...
July 23, 2009 at 9:48 am
Grant Fritchey (7/23/2009)
Yeah, it does seem like a larger & larger percentage of the population are becoming dependent on a smaller & smaller percentage to just give them everything.
On the...
July 23, 2009 at 9:15 am
All indexes have statistics associated with them and those stats cannot be dropped. If you're manually creating stats, it's unlikely you'll get any benefit creating stats on the same column...
July 23, 2009 at 8:43 am
Just checked out the local news. There have been some riots in Mpumalanga, the province to the east of where I live and also in the Western Cape, mostly in...
July 23, 2009 at 8:38 am
Viewing 15 posts - 37,471 through 37,485 (of 49,566 total)