Viewing 15 posts - 3,706 through 3,720 (of 7,164 total)
Many SQL experts I follow and respect (yourself included) caution against accessing large swaths of the proc cache on a live server. I like the idea of setting up a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 2:24 pm
7 different OLE DB Data Sources
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 1:35 pm
IIRC MySQL does not expose metadata in compliance with what the SSIS OLE DB destination requires. You could look into a third party OLE DB driver, or look into upgrading...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 1:34 pm
If it were me I would not take the advice of anyone on a forum for this one. If you have a dev environment, try it there first and find...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 1:31 pm
If the proc in the other schema is explicitly owned and it is not owned by the same owner as the dbo schema then the ownership chain is broken.
Similarly, if...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 12:18 pm
bmanning 59285 (6/27/2012)
I am a newbie, I need to give an access to all tables and stored procedures in the database with
select and view permissions only on SQL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 11:19 am
sudhakara (6/27/2012)
Getting the registry values (service account,authentication mode,etc)through system stored procedures using sql server integration services.
Not getting the error at the first attempt , its...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 9:21 am
ditto
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 9:16 am
I make a distinction between a Catalog View and a System View where the documentation does not. Catalog Views are dependent on the Catalog/Database Context. System Views return the same...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 8:36 am
I've seen similar errors surface. In other cases it pointed towards a bug in the DB engine code. What build are you running?
SELECT SERVERPROPERTY('Edition') AS Edition,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 8:01 am
True, sys.master_files is not technically a DMV. The DMV acronym is pervasive however, so I use it in place of a lot of objects sometimes, even though that is incorrect....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 27, 2012 at 6:30 am
Big brother must have been watching over me. All is well now 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2012 at 8:53 pm
ScottPletcher (6/26/2012)
As I understand it having database files stored across two arrays (data on one array, logs on the other) gives us a better chance of recovering to the point...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2012 at 4:50 pm
Jeff Moden (6/26/2012)
Jeff Moden (6/26/2012)
opc.three (6/26/2012)
Keeping all data in one table, but using a separate filegroup for blobs is a good way to go, and simple.
Actually, it's not. I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2012 at 4:32 pm
SQL_Surfer (6/26/2012)
Autogrow. I had created a DMP to update statistics and rebuild index. Thats when db grew.
Thanks for the response. You said you were in FULL recovery mode. In between...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 26, 2012 at 3:09 pm
Viewing 15 posts - 3,706 through 3,720 (of 7,164 total)