Viewing 15 posts - 5,206 through 5,220 (of 7,502 total)
In fact, schemas are menth to avoid this kind of actions.
SQL2005 wright ?
Schema should be a container for logicaly related objects.
check out ALTER SCHEMA schema_name TRANSFER securable_name
and ALTER AUTHORIZATION
...
February 15, 2008 at 12:30 am
I you honor your dba, give her/him a braek !
A cellphone and a decent laptop should do just fine.
Most companies would be better of by planning their IT actions,
this...
February 15, 2008 at 12:17 am
fwiw it searches for startup procedures...
... Are there startup procs ?
What kind of stuff do they perform ?
If I'm correct the $300 PSS is refunded if it is confirmd as...
February 14, 2008 at 2:41 pm
Today I've received this link and found it to be very to the point !
Windows ITPro
Best Practices for Backup and Restore in SQL Server 2005
February 14, 2008 at 12:34 pm
indeed the service account needs write rights to your unc folder \\Server\inv
That's why most of us use a simple sqlagent job to create backups.
Also if I were to use VB6...
February 14, 2008 at 12:30 pm
indeed, you _must_ use roles ( if you don't want every user to be full SSAS system administrator :crazy: ), but the level of granularity is something you'll have to...
February 14, 2008 at 7:06 am
I was under the impression that to view the advanced config required SQL to be restarted?
An instance restart is certainly not needed to view the advanced config settings !
It...
February 14, 2008 at 5:43 am
Name Min Max Config_value Run_value
----------------------------------------------------
clr enabled 0 1 0 0
confirms CLR is not activated
Would you mind alowing to view all configs ?
That can be done with
-- enable advanced options
exec...
February 14, 2008 at 4:03 am
- can post the results of sp_configure ?
- does your server's windows eventlog mention (memory)bank issues ?
- do you have other issues with this server ?
-What's the minimum server memory...
February 14, 2008 at 1:55 am
There are many levels you can grant read access.
I'm afraid I cannot guide you through it at this time because I haven't played
around with it to know it to the...
February 14, 2008 at 12:44 am
- What's the size of the database ?
- what's the fragmentation level of the objects in the database?
- do you rebuild indexes often ?
- did you perform full database maintenance...
February 13, 2008 at 10:46 am
EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'CMDShellPROXY'
, @login_name=N'thejobowner'
(jobonwer as stated in the job!)
Also keep in mind the windows account that you provided for proxy
needs to have rights to read/write to the path you want...
February 13, 2008 at 7:44 am
join the club :w00t::alien:
February 13, 2008 at 6:31 am
USE [master]
GO
CREATE CREDENTIAL [CMDShellSQLAgentPROXY] WITH IDENTITY = N'awindowsdomain\account', SECRET = N'itspassword'
GO
USE [msdb]
GO
/****** Object: ProxyAccount [CMDShellPROXY] Script Date: 02/06/2007 11:30:44 ******/
EXEC msdb.dbo.sp_add_proxy @proxy_name=N'CMDShellPROXY',@credential_name=N'CMDShellSQLAgentPROXY',
@enabled=1,
@description=N'Provides CMDShell functionality...
February 13, 2008 at 5:34 am
can you post the results of :
restore filelistonly
FROM DISK = 'yourbackuppath and file'
?
February 13, 2008 at 3:39 am
Viewing 15 posts - 5,206 through 5,220 (of 7,502 total)