cant you filter your query to send limited records as much required.
I will suggest you better look for execution plan of the query and then make any...
by default system database are in simple recovery mode. So you will not requried to shrink log as long you havent changed it to full.
select * from msdb..sysjobs
and see the option enabled. If its 1 then enabled = true else false for 0.
I have recently faced the similar problem to recover the data. So would like to share my exp with you to recover the data and hope it helps.
Did you make file DSN to connect? And when you configure this DSN, did you configured it with the account you have provided read only access because...
as behind every profiler there is trace so you can use :-
SELECT * FROM :: fn_trace_getinfo(default)
your question is not clear.
IF you can put some example like what you getting now and what you expect to be return, then it will be easy to code.
it is available in sql 2008 onwards but not in 2005.
But you can use the print command and variables after every line where you want to see the...
try to select the option " select drop" in "choose script options".
It will not be like if exists then drop but it will have syntax like drop table...
good to hear. yes forget to mention the instance name as well within the brackets.
the problem was because sql server not able to understand '-' as...
In addition to this website, some of the others which I found really good are :-
I dont think it will make any difference by putting compatibility mode to 2000 as log shipping need to be configured at server level.
not so exact but you can compare the size of the table. As you mentioned database size is between 50-100gb, then I am sure there would be some 6-12...
is it a specific record or set or records?
Have you tried to update the record by your own. Seems like conflicting with matching condition in where...
yourtable set col4 = cast(col1 as varchar(10))+ cast(col2 as varchar(10)) + cast(col3 as varchar(10))
hope it give you expected...
i dont think anyone going to give you exact solution based on the query you posted because :-
1) quiet long to read
2) not enough time to understand...
put the pointer on the line which you want to debug and then f10 key
i will suggest you explore the net becuase the more you explore, the more your doubt will be clear.
You need to understand the basic and advance of...
check the services configured on which account. It seems the account password is expired or account is locked.
Check the account in Active Directory
Separate names with a comma.