Viewing 15 posts - 346 through 360 (of 1,068 total)
mitch.fh (1/4/2012)
@Suresh:1) Log shipping. Database can be accessed under "stand by" mode
Isn't that just when the source system fails?
No. Secondary database can be accessed (read-only) during log-shipping.
mitch.fh (1/4/2012)
January 4, 2012 at 2:43 am
The error message says 'ms-help://MS.SQLCC.v10' is invalid
Uninstalling and reinstalling only BOL may fix it.
January 3, 2012 at 10:45 pm
Some suggestions:
1) Log shipping. Database can be accessed under "stand by" mode
2) Mirroring: Snapshot database is accessible.
January 3, 2012 at 10:30 pm
From your screen shot it looks like, you are trying to access the BOL from the Internet.
My suggetion is, install BOL locally on your PC's disk. You should be able...
January 3, 2012 at 10:22 pm
sql Anand (1/2/2012)
... The process cannot access the file because it is being used by another process.
Looks like the package is opened by another person or process. Get it closed.
You...
January 2, 2012 at 1:25 am
MyDoggieJessie (12/31/2011)
Checkdb returned:DBCC results for 'Auth_Primary'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
.....
All the...
January 1, 2012 at 11:57 pm
SPID below 50 are system processes which cannot be killed.
December 22, 2011 at 12:51 am
See the BOL. There is a good example for your exact requirement.
December 21, 2011 at 3:09 am
Bhuvnesh (12/20/2011)
waseem.shahzad 45937 (12/19/2011)
I want to Monitor My SQL Server's Database events. Whenever there would be a change in My Schema,Execution of SP/Trigger/View/DDL/DML part>> The User's Machine Name emailed...
December 21, 2011 at 12:14 am
Add the user to SQLAgentOperatorRole on MSDB database.
December 20, 2011 at 9:05 pm
geetha@in (12/19/2011)
I am unable to connect to one of my production sql server using RDP(remote desktop connection).
1) Why do you want to RDP to this server?
2) What is the errror...
December 20, 2011 at 3:59 am
When you add a column using UI, it actually drops and recreates the table. That is why so much time is taken.
If you add the column using ALTER TABLE query,...
December 19, 2011 at 4:53 am
Do you meant to say, it should not be in Full Recovery model?
December 19, 2011 at 4:48 am
Thanks for informing that it worked.
Happy to know that your issue is resolved. 🙂
December 19, 2011 at 2:05 am
Viewing 15 posts - 346 through 360 (of 1,068 total)