Viewing 15 posts - 1 through 15 (of 39 total)
July 7, 2004 at 2:27 pm
I second the motion of sa24. The total combined memory being used by both instance should not exceed the total memory of each server, just in case one system failed...
July 7, 2004 at 2:18 pm
check the originating_server column in msdb..sysjobs table. verify as well the server name (select @@servername) if this match the new name.
July 7, 2004 at 2:11 pm
in addition to the net command to verify the service, you can also try the 'sc' command. The syntax is: sc query <Service Name>
eg.
C:\>sc query SQLServerAgent
SERVICE_NAME: SQLServerAgent
TYPE :...
July 7, 2004 at 1:59 pm
Bear in mind that the # temp tables (table variables) are only open or active during the duration of the session. Once the stored procedure is finished executing, temp tables are...
May 20, 2004 at 8:59 am
what application calls the stored procedure?
May 19, 2004 at 12:51 pm
Always include in the code the grant statement after the procedure has been created. This should not only be for procedures but for all the objects as well. This has...
May 19, 2004 at 12:37 pm
EMs DTS and SQL Agent Job can also execute OS commands such as batch files.
DTS - Execute Process Task
Jobs - Step Type is Operating System Command (cmdExec)
hope this gives you...
May 19, 2004 at 12:24 pm
any error messages?
do you have Sybase Client?
May 19, 2004 at 9:14 am
Are the jobs properly scheduled?
Are the Job's and schedule's enable button checked?
May 19, 2004 at 8:57 am
try this:
- set db option 'trunc log on checkpoint' to true
- in the dts package options, you can set the 'insert batch size' to xxx number of rows.
May 17, 2004 at 7:54 am
there is nothing hard using with bcp as steve suggested, but if you are still not comfortable, use the dts. it has options there to commit every xxx rows.
May 14, 2004 at 12:43 pm
1. install oracle client in the server where your sql server is
2. configure oracle client
3. set up the linked server (if you cannot set it up using sp_???, use the...
May 14, 2004 at 12:30 pm
user aliases are in table sysalternates. verify this table and chech the ids against the syslogins. You can use sp_dropalias to drop the user alias or manually deleting it...
July 14, 2003 at 2:14 pm
Agree with Jay_durai. I dont see a need why you are on a cluster env and need to shutodwn the nodes at the same time. If you are...
July 14, 2003 at 2:05 pm
Viewing 15 posts - 1 through 15 (of 39 total)