Viewing 15 posts - 5,206 through 5,220 (of 7,505 total)
Avoid providing sysadmin rights to non sqlserver applications !
Unless off course it is for a central configuration management system that
really needs to set sqlserver instance properties.
There are several other...
February 15, 2008 at 1:32 am
If DBCC opentran shows open transactions, these will be rolled back if you kill the connections !!!!
In that case you will loose data.
February 15, 2008 at 12:58 am
OT
As you will have noticed, readability is always an issue :doze:
Start using table_aliases in your queries !
e.g.
select you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too .mycolumn
from you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too
inner join the_other_schema.the_other_object_name
on you_know_a_schema_name_can_be_very_long_indeed.wel_you_know_an_object_name_can_be_very_long_too .PK = the_other_schema.the_other_object_name.theFKcol
...
will become
select...
February 15, 2008 at 12:39 am
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
Viewing 15 posts - 5,206 through 5,220 (of 7,505 total)