Viewing 15 posts - 31 through 45 (of 64 total)
irena.bulatovic (9/30/2009)
DB size is 200GB. We have cluster server with 16GB of ram 14GB dedicated for sql[/] and emc storage cx3-20F
Hi, it may seem obvious but do you have AWE...
September 30, 2009 at 4:10 am
I have to look after servers across dev and test domains as well as live etc - so I created sql logins on those machines and can compare them from...
September 29, 2009 at 4:21 am
This script runs against the database you are connected to. This will show the total size of a database file along with the available space left in the file. This...
September 21, 2009 at 9:45 am
I don't think you can - you can only specify the filegroup and then assign this another data file.
September 18, 2009 at 3:07 am
That's true (and I have been caught out by it before) - these days I write my own plans.
As I have backups on tape I delete the oldest on the...
September 18, 2009 at 2:51 am
/****Sorry for multiple replies - the server timed out and I thought it had failed then it put it through twice while I was re-entering it*****/
Thank-you both for your replies...
September 18, 2009 at 2:03 am
If you create the password using a stored procedure and pass it in as a parameter you shouldn't need to escape it.
If not you can check for ' in the...
September 17, 2009 at 9:37 am
sanjeev_krs2004 (9/17/2009)
Its just a simple maintenance plan where I am rebuilding indexes, reorganizing indexes, shrink database...etc. All the usual stuff. Secondly, I am not sure but in past...
September 17, 2009 at 9:33 am
The puzzle for me is that if the table has no primary key defined it works with out any extra permissions. When you link the table access asks for a...
September 14, 2009 at 7:29 am
So...
I created a role in master called accessusers and gave that execute on the proc and then gave the user that role in master.
It still feels slightly dissatisfying though.
September 14, 2009 at 6:59 am
Extending the trace to all dbs I get the error message I needed:
The EXECUTE permission was denied on the object 'sp_execute', database 'mssqlsystemresource', schema 'sys'.
I'm not sure why it calls...
September 14, 2009 at 6:49 am
Hi
I don't think a straight install will require a reboot - but you will probably need to get SSAS to the same service pack level as SQL Server - and...
September 11, 2009 at 9:39 am
Hi
The problem could be the Proc [dbo].[sproc_IndexMaintenance]
Does this [dbo].[sproc_IndexMaintenance] run when called directly eg EXEC [dbo].[sproc_IndexMaintenance]?
When you run the job set does the database context change - and does the...
September 11, 2009 at 9:18 am
Viewing 15 posts - 31 through 45 (of 64 total)