Viewing 15 posts - 1,051 through 1,065 (of 1,166 total)
I don't see any problem copying .ini file from other server.
Try first without copying the dll, let it use local available dll.
I don't think it is going hose the system...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 4:01 pm
If want to execute SQL job on the remote server...
As John mentioned you can use DTS package using Execute Package task OR execute sql task in combination with XP_CMDSHELL..
OR
You...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 3:53 pm
If you are interested..
http://www.developersdex.com/sql/message.asp?p=1925&r=5243447
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 3:45 pm
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
http://support.microsoft.com/kb/224071/en-us
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 3:32 pm
It working fine for me..
Try qualifying using fully qualified name...
exec master..sp_help_log_shipping_monitor
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 3:00 pm
You do that by using SSIS package OR bcp etc..
I didn't get you what you were using in 2000 but If you were using job outfile as .csv file it...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 2:58 pm
Read the following thread for answers...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 1:11 pm
You can use replace function...
select replace(show_name, 'journal','Notebook') as show_name from My_Table where show_name = 'My hunter''s journal'
select replace('abcedfg', 'ab','xx')
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 12:56 pm
Specially third party app databases will have this type object names to secure their propietery information...
Make sure you don't break any contracts with vendor when you create views in the...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 12:14 pm
If I am not mistaken...
RESTORE HEADERONLY for backup files not for mdf/ldf files.
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 12:08 pm
What it shows in you QA option widow Fonts tab?
Check Editor catogery and foregroud colors..
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 12:05 pm
What version and build you are on?
Did you check mini dump files?
You may see procedure info in dump files if it is caused by the user proc.
For exception and acces...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 11:53 am
Looks like to me some kind of corruption...
Are you sure you are attaching the sql 2000 files to sql 2000 server?
Try to run sp_resetstatus and see happens.
Otherwise you can...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 11:49 am
Yes...
If sql backup then you should see SPID...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 11:40 am
Just curious...what is the reason for disabling the backup job which is one of the important one...
You can use msdb..sp_update_job procedure too in QA...
To diable:
exec msdb..sp_update_job @job_name = 'Job...
MohammedU
Microsoft SQL Server MVP
December 6, 2006 at 11:38 am
Viewing 15 posts - 1,051 through 1,065 (of 1,166 total)