Viewing 15 posts - 2,161 through 2,175 (of 2,387 total)
No. It is same as how you create the maintenance plan in non-cluster server.
March 6, 2003 at 12:32 pm
Try sp_tables_ex, sp_columns_ex, sp_primarykeys if the remote SQL Server has been configured as linked server.
March 6, 2003 at 9:38 am
As I remember, During the client tools installation, you have options not to install debuger component. In your case, you may have to reinstall SQL Server.
March 4, 2003 at 6:48 pm
MDAC is sharing resource in the system and it can't be reversed back to old version by reinstall sp2.
Check following link for how to rollback MDAC. This article was authored...
March 4, 2003 at 6:38 pm
We are ruunig SAP in SQL Server 2000 with average 20GB database growth per month. For you situation, you better send SAP message to inquiry or check SAP notes.
Do you...
March 4, 2003 at 11:50 am
You have to install Oracle client in SQL Server machine and ensure the SQL Server box is able to access Oracle database just like any your Oracle workstation.
March 4, 2003 at 8:25 am
Maybe you can try this command.
EXEC sp_columns_ex 'yourlinkedservername', 'yourlinkedtablename'
March 4, 2003 at 8:20 am
Depend on what kind of jobs did you run? It might related to NT permission, SQL Server Agent service account or Agent Proxy account and those account's privilege. Can you...
March 4, 2003 at 8:07 am
Try to configure SQL Agent account with your NT login and should work.
SQL Agent property --> Job System --> uncheck 'Non-SysAdmin job step proxy account' --> click 'Reset Proxy...
March 3, 2003 at 6:04 pm
After update that column with current SQL Server name, you will be able to modify the jobs.
sp_configure 'allow update', 1
go
reconfigure with override
go
use msdb
go
update sysjobs set originating_server = 'yourSQLServername'
go
sp_configure 'allow update',...
March 3, 2003 at 5:53 pm
Is the Access database secure database? Do you place 'admin' as remote login with correct password? Where did you get this error message, EM or QA?
March 3, 2003 at 2:17 pm
Check whether the originating_server name from sysjobs table is different than SQL Server name, If it does, you have to update this column with SQL Server name in table sysjobs...
March 3, 2003 at 2:09 pm
Call Microsoft to request that hotfix and it looks like this hotfix is already be included in service pack 2 according to the version.
February 28, 2003 at 12:11 pm
Which option did you choose on 'Recovery completion state' when you restored the full backup?
Did you check 'force restore over existing database'?
Edited by - Allen_Cui on 02/28/2003 10:18:52 AM
February 28, 2003 at 10:18 am
Viewing 15 posts - 2,161 through 2,175 (of 2,387 total)