Viewing 15 posts - 751 through 765 (of 1,539 total)
What we want to do now is switch to 4 data and 1 log LUN for every DB
Why do you want to do this to all databases? I guess...
July 9, 2009 at 7:11 am
Colin Bickford (7/9/2009)
I was recently asked to supply 3 questions for use in an interview.
I should say though that the post-holder was only expected to be able to use...
July 9, 2009 at 7:03 am
Earlier in the day i used to get a huge page full of error messages.
Now i'm gettin this.
The following error occurred...
Sorry the application encountered an unexpected error....
July 9, 2009 at 6:54 am
Saravanan_tvr (7/9/2009)
When we shrinking the database , that will reduce the database Size
But I need to know, Actually what happen in while shrinking,
Is there is any data...
July 9, 2009 at 6:52 am
restore filelistonly from disk='backup file name'
see BOL for details
July 9, 2009 at 6:49 am
you can think of using xp_cmdshell in this case.
Am guessing there must be a backup job. edit the job to add a new job step after backup which will...
July 9, 2009 at 1:48 am
ramuvanparti (7/8/2009)
ps (7/8/2009)
July 8, 2009 at 1:06 am
You need to manage your identity columns
For publisher you should provide a different range and for subscriber you should provide a different range so that conflicts do not occur
July 8, 2009 at 12:57 am
If you are entering same records in both publisher and subscriber, the record originating from the publisher takes precedence over the one originating from the subscriber by the conflict resolver...
July 8, 2009 at 12:06 am
There are three new roles in MSDB database in 2005 which relate to jobs.
1. SQLAgentUserRole
2. SQLAgentReaderRole
3. SQLAgentOperatorRole
Check out Here for details
July 7, 2009 at 9:37 am
Viewing 15 posts - 751 through 765 (of 1,539 total)