Viewing 15 posts - 511 through 525 (of 611 total)
Hi EdVassie!
This is exactly what I meant! Companies that don't have a suitable business continuity plan in the event that something goes horribly awry are the ones that will...
April 2, 2013 at 7:58 am
I have just thought of a couple of things that may help...
You can group your users into groups, either via AD (if you have it) or using Local Users and...
April 1, 2013 at 9:28 am
I am not sure that not being able to Access data on a database is going to be the cause of bankruptcy unless the comapny in question has made some...
March 31, 2013 at 10:18 am
Red8Rain (2/7/2011)
who's the dbo for the database?try running sp_changedbowner 'sa' on the db.
I wouldn't recommend the Approach of using 'sa'. Either create an AD user and use that as...
March 31, 2013 at 10:11 am
Boy, you are not in an enviable Position!
In your case, Trial and error is going to be one of your best bets as bad as that advice might Sound. ...
March 31, 2013 at 10:09 am
Ross McMicken (3/27/2013)
kevaburg (3/20/2013)
March 27, 2013 at 10:20 am
Sorry this answer took so long.....our Oracle world has been playing up!
For Production server backups we use BackupExec from Symantec for the databases and system snapshots for the server through...
March 26, 2013 at 7:22 am
That is what I said earlier.....the problem is that SQL Server cannot natively read members out of an AD group confgiured as a login in SQL Server itself.
I am a...
March 26, 2013 at 7:06 am
GilaMonster (3/25/2013)
kevaburg (3/25/2013)
Information related to non-clustered indexes are stored as a view in the MASTER database named sys.partitions.
The view definition is in the system resource database. The data that...
March 25, 2013 at 9:14 am
Sorry Lynn.....it was aimed at the original poster....
March 25, 2013 at 8:48 am
OK, I didn't read your question properly so sorry about that.
That said......
Information related to non-clustered indexes are stored as a view in the MASTER database named sys.partitions. ...
March 25, 2013 at 8:13 am
Sorry for saying this but whether it is PL-SQL or T-SQL is somewhat irrelevant......the results you expected are somewhat basic and not particularly taxing. Are you sure this person...
March 25, 2013 at 7:58 am
Sean Lange (3/21/2013)
mehta.saurabhj (3/21/2013)
tim_harkin (3/21/2013)
If you are talking about the index definitions, then yes they are still there. Index data is gone - their pages are deallocated as well.
I...
March 25, 2013 at 7:49 am
Alot depends on a lot of things. For example how much data can you afford to lose, or better worded, is allowable in the worst case scenario? How...
March 25, 2013 at 7:44 am
Viewing 15 posts - 511 through 525 (of 611 total)