Viewing 15 posts - 1,051 through 1,065 (of 1,165 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...
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...
December 6, 2006 at 3:53 pm
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
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
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...
December 6, 2006 at 2:58 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')
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...
December 6, 2006 at 12:14 pm
If I am not mistaken...
RESTORE HEADERONLY for backup files not for mdf/ldf files.
December 6, 2006 at 12:08 pm
What it shows in you QA option widow Fonts tab?
Check Editor catogery and foregroud colors..
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...
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...
December 6, 2006 at 11:49 am
Yes...
If sql backup then you should see SPID...
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...
December 6, 2006 at 11:38 am
Viewing 15 posts - 1,051 through 1,065 (of 1,165 total)