Viewing 15 posts - 3,016 through 3,030 (of 9,715 total)
I apparently am not understanding what your needs are. Do you need to size the database for auto-growth? Are you trying to add more space to the drive where your...
December 11, 2014 at 6:59 am
pdanes (12/11/2014)
Brandie Tarvin (12/11/2014)
What is the business need to use a schema object to prevent this?
I didn't specify schema, and in fact, have no idea how a schema could be...
December 11, 2014 at 6:56 am
ramana3327 (12/10/2014)
Hi,We have a login with windows authentication. That login has sysadmin and public server roles. But We didn't map that login to some user databases.
There is your answer right...
December 11, 2014 at 6:45 am
Was it perhaps granted only on the database level security then?
I.E., try opening up the Database, going to Security, and adding a new user via the GUI.
If that doesn't work,...
December 11, 2014 at 6:43 am
What is the business need to use a schema object to prevent this?
December 11, 2014 at 6:41 am
Oh, for heaven's sake. After all this grief with the job and the task, it turns out the problem is the file isn't zipping up properly because a .lst file...
December 11, 2014 at 6:39 am
Did you upgrade from SQL 2005 or SQL 2000? It might be a holdover from one of those.
Also, it is entirely possible the login was orphaned (the server level login...
December 11, 2014 at 6:16 am
I calculate it based on what the database seems to need.
Are you creating new databases or trying to calculate this for existing databases?
Also, what you really need to know is...
December 11, 2014 at 6:14 am
Eric M Russell (12/10/2014)
lshanahan (11/26/2014)
Markus (11/25/2014)
December 10, 2014 at 12:12 pm
William Assaf (12/9/2014)
I bet it's permissions.
From MSDN:
http://msdn.microsoft.com/en-us/library/ms187354.aspx
"Only members of sysadmin can modify a schedule owned by another...
December 10, 2014 at 4:30 am
jimmyjjohns08 (12/7/2014)
On every machine where you want to run an SSIS package, you need to install the Integration Services components, using the SQL Server media.
That's not what he is doing,...
December 9, 2014 at 4:22 am
psc032802 (12/5/2014)
I do not have much access overall. Just read access to one database and I cannot see what...
December 5, 2014 at 11:43 am
Ed Wagner (12/5/2014)
Brandie Tarvin (12/5/2014)
GilaMonster (12/5/2014)
And crisis, panic, run around screaming, the EF-based app is slow.600MB database, generating 5GB of trace data in 1 hour....
Here's a bit of easy...
December 5, 2014 at 5:31 am
psc032802 (12/4/2014)
December 5, 2014 at 4:52 am
GilaMonster (12/5/2014)
And crisis, panic, run around screaming, the EF-based app is slow.600MB database, generating 5GB of trace data in 1 hour....
Here's a bit of easy code to solve the...
December 5, 2014 at 4:48 am
Viewing 15 posts - 3,016 through 3,030 (of 9,715 total)