Viewing 15 posts - 1,651 through 1,665 (of 2,387 total)
Have you tried to use 'SET DATEFORMAT dmy'?
June 10, 2003 at 1:49 pm
Read http://support.microsoft.com/default.aspx?scid=kb;en-us;306655
Quoted
"You must investigate this particular problem from the standpoint of whether SQL Mail is properly configured as described in the following Microsoft Knowledge Base article:
263556 INF: How to Configure...
June 10, 2003 at 11:47 am
ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the owner of the procedure, and are not transferable.
...
June 10, 2003 at 11:36 am
As long as he has the create permission and own the objects, He will be able to alter it too.
June 10, 2003 at 10:08 am
quote:
Now onto copying production database to this server. Would you know of easiest way to do so why maintaining all user...
June 10, 2003 at 7:56 am
Check the job owner and change it to 'sa'.
June 10, 2003 at 7:35 am
quote:
restore database ProdCPWQuote from tapedrive with file = 40, unload, stats,norecovery, replace,
move 'prodcpwquotelog' TO 'D:\atlantic\prod\cpwquote\db\prodcpwquotelog.ldf'
June 10, 2003 at 7:25 am
Changing 'sa' password shouldn't affect your jobs unless there is 'password hardcode' in the jobs.
You seems changed the SQL Server service account password, Isn't it?
June 9, 2003 at 8:36 pm
Danschl
Please double check the definition of 'Total server memory' from performance monitor. You also can refer to following tips.
http://www.sql-server-performance.com/performance_monitor_counters_memory.asp
Quote
"Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and...
June 9, 2003 at 8:09 pm
Run it from QA from master database. You need 'sa' or 'security admin' right to run it. Ask your DBA to help.
June 9, 2003 at 2:30 pm
If you are sure the IUSR account has to access SQL Server, run sp_grantlogin 'tordev01\iusr_tordev01' and assign proper permissions to it. (Change tordev01 to your server name).
June 9, 2003 at 2:22 pm
According to perfmon definition, 'maximum workspace memory' is the total amount of memory granted to executing processes. This memory is used primarily for hash, sort and create index operations.
June 9, 2003 at 1:37 pm
Do not understand some of questions here but system table sysperfinfo may be the one you are looking for.
June 9, 2003 at 12:19 pm
Viewing 15 posts - 1,651 through 1,665 (of 2,387 total)