Hi, how can I change the default path for the full text catalog location? I think it's a registry update but I can't find it. Any ideas? I used to...
Can anyone point out why it is not advisable to restore a database across the network? I have always chose to copy the .bak file and then restore...
Hi, is it possible to have trans replication going and have FT Search on that database as well? How would you set this up if it is possible. thanks
I've read this article and the question I have is whether stopping and restarting the search service will kick off repopulation of the indexes. Do...
I accidentally put this post under log shipping so sorry for the duplication. Hi, we have a process that dump/copies/loads nightly from server A to...
Hi, we have a process that dump/copies/loads nightly from server A to server B. Server B has the database as read only. There are Full text...
select @@servername on both servers returns the correct value
sorry for the delay in replying to this post. I found that the source_destination in the log_shipping_primaries was defaulting to NULL. When I...
hello, quick question about what account do I log in as when I'm installing sql server on a cluster. I thought it should be the sql server service...
I've set up log shipping between two trusted servers and the copy job is not working. If I manually copy the logs over the restore picks them up and...
so this is what I'm being told and makes sense. If I turn off the "allow nested triggers" it will not run these nested triggers and therefore it...
yes. The procedure hits 33 and dies. If I turn off the allow nested triggers the code works.
hi, we have encountered an error from a dev that states: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit32) when...
Separate names with a comma.
