Viewing 15 posts - 5,656 through 5,670 (of 9,707 total)
Chris,
I haven't forgotten you. I'm just trying to figure out why your server thinks the filegroup or the file within it is offline. Because that does appear to be the...
June 22, 2011 at 8:03 am
Perry Whittle (6/21/2011)
Brandie Tarvin (6/21/2011)
Perry Whittle (6/21/2011)
you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode
Apparently, I'm...
June 22, 2011 at 8:01 am
Glad you found your issue and thanks for posting the details about it.
June 22, 2011 at 8:00 am
jessyb (6/21/2011)
Thank you both for your time & help. I do appreciate it.xp_enumerrorlogs is perfect - can't believe I didn't find it before.
Me too. That's definitely one that's...
June 22, 2011 at 7:57 am
Bhuvnesh (6/22/2011)
so i ran
DBCC CheckDB with ALL_ERRORMSGS
and got below error
Msg 8921, Level 16, State 1,...
June 22, 2011 at 6:50 am
Ken Garrett (6/20/2011)
June 21, 2011 at 12:44 pm
Perry Whittle (6/21/2011)
you dont seem to have made any provision for scenarios when a database name is passed in that is in Simple recovery mode
Apparently, I'm missing the context of...
June 21, 2011 at 12:42 pm
It does sort of does make sense. And you're correct. There's no way I know of to use the BIDS solution to set up that information.
Our developers use a SQL...
June 21, 2011 at 12:28 pm
Have you had any service pack updates or anything applied to your box or the server recently? Right about the same time that this error started.
June 21, 2011 at 12:23 pm
GSquared (6/21/2011)
SSIS job and they don't know about derived columns????
Is that the part where I make something up and hope it fits with the rest of the data?
@=)
How can...
June 21, 2011 at 11:09 am
Steve Jones - SSC Editor (6/20/2011)
GabyYYZ (6/20/2011)
Anyone know if he has official Microsoft MVP designation, either now, or in the past?
AFAIK, he never has. Not enough contributions to the SQL...
June 20, 2011 at 12:26 pm
What queries have you tried based on the above table schema?
June 20, 2011 at 12:15 pm
Then it's my bad.
June 20, 2011 at 9:37 am
opc.three,
I think you're mixing this post up with another thread. There is no requirement for 60 days in the OP that I can see. The OP says "all files."
June 20, 2011 at 9:07 am
You can query on sys.Filegroups.
June 20, 2011 at 9:04 am
Viewing 15 posts - 5,656 through 5,670 (of 9,707 total)